<?xml version="1.0" encoding="UTF-8"?> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" baseTable="csh_terminal_manager" needAccessControl="false" xmlns:o="leaf.database.local.oracle" xmlns:f="leaf.database.features" alias="t1"> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ SELECT * FROM ( select manager_id,terminal_number,administrant,agent_id, (select EXTRA_NAM from HLS_BP_MASTER where bp_id = ctm.agent_id) agent_name, provide_date,hand_over_date,enabled_flag,use_zone,notes from csh_terminal_manager ctm order by manager_id )t1 #WHERE_CLAUSE# #ORDER_BY_CLAUSE# ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:fields> <bm:field name="manager_id"/> <bm:field name="terminal_number"/> <bm:field name="administrant"/> <bm:field name="use_zone"/> <bm:field name="agent_id"/> <bm:field name="agent_name" forUpdate="false" forInsert="false"/> <bm:field name="provide_date" datatype="java.util.Date"/> <bm:field name="hand_over_date" datatype="java.util.Date"/> <bm:field name="enabled_flag"/> <bm:field name="notes"/> </bm:fields> <bm:features> <f:standard-who/> <o:sequence-pk/> </bm:features> <bm:primary-key> <bm:pk-field name="manager_id"/> </bm:primary-key> <bm:query-fields> <bm:query-field name="terminal_number" queryExpression="t1.terminal_number = ${@terminal_number}"/> <bm:query-field name="administrant" queryExpression="t1.administrant like '%'||${@administrant}||'%'"/> <bm:query-field name="agent_name" queryExpression="t1.agent_name like '%'||${@agent_name}||'%'"/> <bm:query-field name="provide_date" queryExpression="t1.provide_date = to_date(${@provide_date},'yyyy-mm-dd')"/> <bm:query-field name="hand_over_date" queryExpression="t1.hand_over_date = to_date(${@hand_over_date},'yyyy-mm-dd')"/> <bm:query-field name="enabled_flag" queryExpression="t1.enabled_flag = ${@enabled_flag}"/> </bm:query-fields> </bm:model>