<?xml version="1.0" encoding="UTF-8"?> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false"> <bm:fields> <bm:field name="period_name" forQuery="true" forDisplay="true" physicalName="period_name" prompt="期间"/> </bm:fields> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ select* from( select p.period_name from gld_periods p where p.period_set_code = 'STD_PERIOD' and p.adjustment_flag= 'N' and p.period_name>'2015-13' order by p.internal_period_num)t #WHERE_CLAUSE# ]]> </bm:query-sql> </bm:operation> </bm:operations> <bm:query-fields> <bm:query-field name="period_name" queryExpression="t.period_name like '%'||${@period_name}||'%'"/> </bm:query-fields> </bm:model>