business_mail.lwm 1.17 KB
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36
<?xml version="1.0" encoding="UTF-8"?>
<!--
    $Author: huangtianyang
    $Date: 2018/9/18 上午10:58
    $Revision: 1.0 
-->
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
                SELECT
                    bc.business_id,
                    bc.BUSINESS_SUBJECT subject,
                    bc.BUSINESS_TEXT BODY,
                    bc.BUSINESS_CONTACT_NUMBER,
                    bc.BUSINESS_RECS mail_to_id,
                    bc.BUSINESS_CCS mail_cc_id,
                    bc.BUSINESS_STATUS,
                    bc.CREATED_BY CREATED_USER,
                    bc.BUSINESS_RECS
                FROM
                    BUSINESS_CONTACTS bc
                    #WHERE_CLAUSE#
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:features>
        <standard-who/>
    </bm:features>
    <bm:primary-key>
        <bm:pk-field name="business_id"/>
    </bm:primary-key>
    <bm:query-fields>
        <bm:query-field name="business_id" queryExpression="business_id = ${@business_id}"/>
    </bm:query-fields>
</bm:model>