<?xml version="1.0" encoding="UTF-8"?> <bm:model xmlns:bm="http://www.leaf-framework.org/schema/bm" needAccessControl="false"> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ select to_number(to_char(sysdate, 'YYYYMM')) value_code, to_char(sysdate, 'YYYY') || '年' || to_char(sysdate, 'MM') || '月' value_name from dual union select to_number(to_char(add_months(sysdate, -1), 'YYYYMM')) value_code, to_char(add_months(sysdate, -1), 'YYYY') || '年' || to_char(add_months(sysdate, -1), 'MM') || '月' value_name from dual
--union --select to_number(to_char(add_months(sysdate, -2), 'YYYYMM')) value_code, -- to_char(add_months(sysdate, -2), 'YYYY') || '年' || -- to_char(add_months(sysdate, -2), 'MM') || '月' value_name -- from dual --union --select to_number(to_char(add_months(sysdate, -3), 'YYYYMM')) value_code, -- to_char(add_months(sysdate, -3), 'YYYY') || '年' || -- to_char(add_months(sysdate, -3), 'MM') || '月' value_name -- from dual
order by value_code desc ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:data-filters><![CDATA[ ]]></bm:data-filters> </bm:model>