<?xml version="1.0" encoding="UTF-8"?> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm"> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ select * from (select a.cf_item, a.description from hls_cashflow_item a where a.cf_direction = 'INFLOW' and a.enabled_flag = 'Y' and a.cf_type not in (1, 9, 100, 101) and a.cf_item in (2,3,4,51,53,61,71,8,11,12,501,611)) t #WHERE_CLAUSE# ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:fields> <bm:field name="cf_item" displayWidth="80" forDisplay="true" forQuery="true" prompt="CON305.CF_ITEM" /> <bm:field name="description" displayWidth="80" forDisplay="true" forQuery="true" prompt="CON711.CF_DIRECTION" /> </bm:fields> <bm:query-fields > <bm:query-field field="cf_item" queryOperator="like" /> <bm:query-field field="description" queryOperator="like" /> </bm:query-fields> </bm:model>