<?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
                        t1.oa_id,
                        t2.submitted_by,
                        t3.user_desc user_name,
                        t4.DESCRIPTION position_name,
                        t5.unit_name
                    FROM
                        bgfl_oa_auto t1,
                        zj_wfl_workflow_instance t2,
                        exp_emp_user_e_v t3,
                        exp_org_position_vl t4,
                        exp_org_unit_v t5
                    WHERE
                        t1.wfl_instance_id = t2.instance_id AND
                        t2.submitted_by    = t3.user_id AND
                        t3.position_id     = t4.POSITION_ID AND
                        t4.UNIT_ID         = t5.unit_id
                    ) tt #WHERE_CLAUSE#
            ]]></bm:query-sql>
        </bm:operation>
    </bm:operations>
    <bm:data-filters>
        <bm:data-filter enforceOperations="query" expression="(tt.oa_id=${@oa_id})"/>
    </bm:data-filters>
</bm:model>
