大家好,我想咨询一下,为什么日期区间这样写报表刷新页面是空白的?(起始和终止的时间默认值为空)就算为空的话也应该能将所有时间段的时间都展示出来的吧?
谢谢大家的帮助 截图如下:
默认值:
参考:下拉框参数为空选择全部-https://help.fanruan.com/finereport/doc-view-2394.html
————————————————————————————————
${if(len(START_DATE) == 0,"","and DATE >= '"+START_DATE +"' ")}
${if(len(END_DATE) == 0,"","and DATE <= '"+END_DATE +"' ")}
select * from 表名称
where 1=1
${if(len(START_DATE) == 0,"","and DATE >= '" + START_DATE+"'" )}
${if(len(END_DATE) == 0,"","and DATE <= '" + END_DATE+ "'")}