<?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 cc.contract_number, cc.contract_id, cc.bp_id_tenant_n from con_contract_lv cc #WHERE_CLAUSE# ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:fields> <bm:field name="contract_number" databaseType="VARCHAR2" datatype="java.lang.String" forDisplay="true" forQuery="true" physicalName="CONTRACT_NUMBER" prompt="合同号"/> <bm:field name="contract_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONTRACT_ID"/> <bm:field name="bp_id_tenant_n" databaseType="VARCHAR2" datatype="java.lang.String" forDisplay="true" forQuery="true" physicalName="BP_ID_TENANT_N" prompt="承租人"/> </bm:fields> <bm:data-filters> <bm:data-filter enforceOperations="query" expression="cc.contract_status not in ('TERMINATE','CANCEL') and cc.data_class= 'NORMAL'"/> </bm:data-filters> <bm:query-fields> <bm:query-field field="contract_number" queryOperator="like"/> <bm:query-field field="bp_id_tenant_n" queryOperator="like"/> </bm:query-fields> </bm:model>