<?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_char(to_date(month||'01','YYYYMMDD'),'YYYY-MM-DD') AS DAY_1, to_char(to_date(month||'01','YYYYMMDD') +1,'YYYY-MM-DD') AS DAY_2, to_char(to_date(month||'01','YYYYMMDD') +2,'YYYY-MM-DD') AS DAY_3, to_char(to_date(month||'01','YYYYMMDD') +3,'YYYY-MM-DD') AS DAY_4, to_char(to_date(month||'01','YYYYMMDD') +4,'YYYY-MM-DD') AS DAY_5, to_char(to_date(month||'01','YYYYMMDD') +5,'YYYY-MM-DD') AS DAY_6, to_char(to_date(month||'01','YYYYMMDD') +6,'YYYY-MM-DD') AS DAY_7, to_char(to_date(month||'01','YYYYMMDD') +7,'YYYY-MM-DD') AS DAY_8, to_char(to_date(month||'01','YYYYMMDD') +8,'YYYY-MM-DD') AS DAY_9, to_char(to_date(month||'01','YYYYMMDD') +9,'YYYY-MM-DD') AS DAY_10, to_char(to_date(month||'01','YYYYMMDD') +10,'YYYY-MM-DD') AS DAY_11, to_char(to_date(month||'01','YYYYMMDD') +11,'YYYY-MM-DD') AS DAY_12, to_char(to_date(month||'01','YYYYMMDD') +12,'YYYY-MM-DD') AS DAY_13, to_char(to_date(month||'01','YYYYMMDD') +13,'YYYY-MM-DD') AS DAY_14, to_char(to_date(month||'01','YYYYMMDD') +14,'YYYY-MM-DD') AS DAY_15, to_char(to_date(month||'01','YYYYMMDD') +15,'YYYY-MM-DD') AS DAY_16, to_char(to_date(month||'01','YYYYMMDD') +16,'YYYY-MM-DD') AS DAY_17, to_char(to_date(month||'01','YYYYMMDD') +17,'YYYY-MM-DD') AS DAY_18, to_char(to_date(month||'01','YYYYMMDD') +18,'YYYY-MM-DD') AS DAY_19, to_char(to_date(month||'01','YYYYMMDD') +19,'YYYY-MM-DD') AS DAY_20, to_char(to_date(month||'01','YYYYMMDD') +20,'YYYY-MM-DD') AS DAY_21, to_char(to_date(month||'01','YYYYMMDD') +21,'YYYY-MM-DD') AS DAY_22, to_char(to_date(month||'01','YYYYMMDD') +22,'YYYY-MM-DD') AS DAY_23, to_char(to_date(month||'01','YYYYMMDD') +23,'YYYY-MM-DD') AS DAY_24, to_char(to_date(month||'01','YYYYMMDD') +24,'YYYY-MM-DD') AS DAY_25, to_char(to_date(month||'01','YYYYMMDD') +25,'YYYY-MM-DD') AS DAY_26, to_char(to_date(month||'01','YYYYMMDD') +26,'YYYY-MM-DD') AS DAY_27, to_char(to_date(month||'01','YYYYMMDD') +27,'YYYY-MM-DD') AS DAY_28, to_char(to_date(month||'01','YYYYMMDD') +28,'YYYY-MM-DD') AS DAY_29, to_char(to_date(month||'01','YYYYMMDD') +29,'YYYY-MM-DD') AS DAY_30, to_char(to_date(month||'01','YYYYMMDD') +30,'YYYY-MM-DD') AS DAY_31 FROM RPT5010_DAY_REPORT where month = ${@month} and rownum=1 ]]></bm:query-sql> </bm:operation> </bm:operations> <bm:data-filters><![CDATA[ ]]></bm:data-filters> </bm:model>