ibatis-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Brandon Goodin (JIRA)" <ibatis-...@incubator.apache.org>
Subject [jira] Commented: (IBATIS-238) Property of a bean from a list can not be used in a dynamic query in elements isEquals and so on
Date Wed, 04 Jan 2006 09:31:01 GMT
    [ http://issues.apache.org/jira/browse/IBATIS-238?page=comments#action_12361727 ] 

Brandon Goodin commented on IBATIS-238:

There is a whiteboard discussion on a future dynamic sql implementation. I have worked extensively
on this code and i would caution us to push this much further. It is difficult code to manage
and change without breaking things. I would recommend that we devote ourselves to consideration
of the next implementation of dynamic sql and not spend too much time on the current. I am
going to look through the issues to find current dynamic sql reports to see what can be done
to accomodate current desired features.

Improved Dynamic SQL Whiteboard:

> 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">
>         <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:
For more information on JIRA, see:

View raw message