gld_get_reference.lwm 753 Bytes
Newer Older
Spencer Chang's avatar
Spencer Chang committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:o="leaf.database.local.oracle" xmlns:bm="http://www.leaf-framework.org/schema/bm" xmlns:f="leaf.database.features" needAccessControl="false">
    <bm:operations>
        <bm:operation name="query">
            <bm:query-sql><![CDATA[
        		select b.type,a.refference_1,b.sql_query from gld_company_accounts a,gld_ref_code_categories b
                where a.account_id=${/parameter/@account_id} and 
                b.ref_code_category_id = a.refference_1
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:data-filters>
        <bm:data-filter enforceOperations="query" expression="a.company_id = ${/session/@company_id}"/>
    </bm:data-filters>
</bm:model>