<sql id="abatorgenerated_Example_Where_Clause" >
 <!--
 WARNING - This element is automatically generated by Abator for iBATIS, do not modify.
 This element was generated on Wed Jan 05 11:36:25 CST 2011.
 -->
 <iterate property="oredCriteria" conjunction="or" prepend="where" removeFirstPrepend="iterate" >
 <isEqual property="oredCriteria[].valid" compareValue="true" >
 (
 <iterate prepend="and" property="oredCriteria[].criteriaWithoutValue" conjunction="and" >
 $oredCriteria[].criteriaWithoutValue[]$
 </iterate>
 <iterate prepend="and" property="oredCriteria[].criteriaWithSingleValue" conjunction="and" >
 $oredCriteria[].criteriaWithSingleValue[].condition$
 #oredCriteria[].criteriaWithSingleValue[].value#
 </iterate>
 <iterate prepend="and" property="oredCriteria[].criteriaWithListValue" conjunction="and" >
 $oredCriteria[].criteriaWithListValue[].condition$
 <iterate property="oredCriteria[].criteriaWithListValue[].values" open="(" close=")" conjunction="," >
 #oredCriteria[].criteriaWithListValue[].values[]#
 </iterate>
 </iterate>
 <iterate prepend="and" property="oredCriteria[].criteriaWithBetweenValue" conjunction="and" >
 $oredCriteria[].criteriaWithBetweenValue[].condition$
 #oredCriteria[].criteriaWithBetweenValue[].values[0]# and
 #oredCriteria[].criteriaWithBetweenValue[].values[1]#
 </iterate>
 )
 </isEqual>
 </iterate>
 </sql>