<?xml version="1.0" encoding="UTF-8"?>
<bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false" defaultOrderBy="t2.monthlist desc">
<bm:operations>
<bm:operation name="query">
<bm:query-sql><![CDATA[
select * from(
select substr(t1.monthlist, 1, 4) yearlist, t1.monthlist
from (SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2007-01', 'yyyy-MM'), ROWNUM - 1),
'yyyy-MM') as monthlist
FROM DUAL
CONNECT BY ROWNUM <=
months_between(to_date('2107-01', 'yyyy-MM'),
to_date('2007-01', 'yyyy-MM')) + 1) t1) t2
#WHERE_CLAUSE#
]]></bm:query-sql>
</bm:operation>
</bm:operations>
<bm:fields>
<bm:field name="yearlist" forDisplay="true" forQuery="true" prompt="年份"/>
<bm:field name="monthlist" forDisplay="true" forQuery="true" prompt="月份"/>
</bm:fields>
<bm:query-fields>
<bm:query-field name="monthlist" queryExpression="t2.monthlist like ${@monthlist}"/>
<bm:query-field name="yearlist" queryExpression="t2.yearlist like ${@yearlist}"/>
</bm:query-fields>
</bm:model>
-
Spencer Chang authoredbfd31bca