record_search

The following is an example of a constraint to be used when RECORD_ACTION=RECORD_SEARCH is used:

<constraint>
	<name>TestSQLIN</name>
	<description>Test Get with SQL query using IN</description>
	<usefor>
	    <var>Installments</var>
	</usefor>
	<condition>
	  <eq>
	    <var>RECORD_ACTION</var>
	    <const type="string">RECORD_SEARCH</const>
    </eq>
	</condition>
	  <action>
	    <select>
       <table source="datasource">
	     <literal>CUSTDS1</literal>
	     <literal>INSTALLMENT</literal>
	      <where>
		      <sql>
	  	      <in>
			        <literal>INSTALLMENT</literal>
			        <const type="number">34000</const>
			        <const type="number">23000</const>
		        </in>
		      </sql>
	       </where>
	      </table>
	    </select>
	  </action>
	</constraint>