<?xml version="1.0" encoding="UTF-8"?> <bm:model xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="HLS_BP_MASTER" needAccessControl="false"> <bm:fields> <bm:field name="bp_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="BP_ID" prompt="HLS_BP_MASTER.BP_ID"/> <bm:field name="bp_code" databaseType="VARCHAR2" datatype="java.lang.String" forDisplay="true" forQuery="true" physicalName="BP_CODE" prompt="HLS_BP_MASTER.BP_CODE"/> <bm:field name="bp_name" databaseType="VARCHAR2" datatype="java.lang.String" forDisplay="true" forQuery="true" physicalName="BP_NAME" prompt="HLS_BP_MASTER.BP_NAME"/> </bm:fields> <bm:features> <f:standard-who/> </bm:features> <bm:primary-key> <bm:pk-field name="bp_id"/> </bm:primary-key> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ select * from (SELECT hbm.bp_id bp_id, hbm.bp_name bp_name, hbm.bp_code bp_code FROM hls_bp_master hbm WHERE hbm.enabled_flag = 'Y' AND hbm.bp_category = 'AGENT') #WHERE_CLAUSE# ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:query-fields> <bm:query-field name="bp_code" queryExpression="bp_code=${@bp_code}"/> <bm:query-field name="bp_name" queryExpression="bp_name=${@bp_name}"/> </bm:query-fields> </bm:model>