[ http://issues.apache.org/jira/browse/IBATIS-238?page=comments#action_12361574 ]
Martin Zeltner commented on IBATIS-238: --------------------------------------- No it works only for one array, but I didn't tested it. I think too that a forEach variable would be the better way than [] like it is now. BTW I have also problems to access a List from a Map. I couldn't make it work. > Property of a bean from a list can not be used in a dynamic query in elements > isEquals and so on > ------------------------------------------------------------------------------------------------ > > Key: IBATIS-238 > URL: http://issues.apache.org/jira/browse/IBATIS-238 > Project: iBatis for Java > Type: Bug > Components: SQL Maps > Versions: 2.1.6 > Environment: WinXp > Reporter: Martin Zeltner > Priority: Critical > Attachments: baseprobe_patch.txt > > A property of a bean that is in a list can not be used for testing. See > attribute "property" of elements "isEquals" from example below: > <select id="searchKeywords" resultMap="keyword" parameterClass="list"> > select KEYID, NAME, DESCRIPTION, OPTIMISTICLOCKINGVERSION from > KEYWORDS > <iterate prepend="where" conjunction="and"> > <isEqual property="[].type" compareValue="like"> > <isEqual property="[].field" compareValue="name"> > <isEqual property="[].caseSensitive" compareValue="true"> > NAME like #[].stringValue# > </isEqual> > <isNotEqual property="[].caseSensitive" > compareValue="true"> > upper(NAME) like upper(#[].stringValue#) > </isNotEqual> > </isEqual> > <isEqual property="[].field" compareValue="description"> > <isEqual property="[].caseSensitive" compareValue="true"> > DESCRIPTION like #[].stringValue# > </isEqual> > <isNotEqual property="[].caseSensitive" > compareValue="true"> > upper(DESCRIPTION) like upper(#[].stringValue#) > </isNotEqual> > </isEqual> > </isEqual> > </iterate> > order by NAME > </select> > Regards, > Martin -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira