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 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