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

Reply via email to