<?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 t.config_id, t.config_code, t.description description_desc,oa_parameter1_sql
            ,oa_parameter2_sql,oa_parameter3_sql
  from bgfl_oa_auto_config t
 where t.enabled_flag = 'Y') #WHERE_CLAUSE#
 ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:fields>
        <bm:field name="config_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="CONFIG_ID"/>
        <bm:field name="config_code" databaseType="VARCHAR2" datatype="java.lang.String" forDisplay="true" forQuery="true" physicalName="CONFIG_CODE" prompt="方案代码"/>
        <bm:field name="description_desc" databaseType="VARCHAR2" datatype="java.lang.String" forDisplay="true" forQuery="true" physicalName="DESCRIPTION" prompt="描述"/>
        <bm:field name="oa_parameter1_sql" databaseType="VARCHAR2" datatype="java.lang.String"/>
        <bm:field name="oa_parameter2_sql" databaseType="VARCHAR2" datatype="java.lang.String"/>
        <bm:field name="oa_parameter3_sql" databaseType="VARCHAR2" datatype="java.lang.String"/>
    </bm:fields>
    <bm:query-fields>
        <bm:query-field name="config_code" queryExpression="upper(config_code) like &apos;%&apos; || UPPER(${@config_code})"/>
        <bm:query-field name="description_desc" queryExpression="upper(description_desc) like &apos;%&apos;||upper(${@description_desc})||&apos;%&apos;"/>
    </bm:query-fields>
</bm:model>
