select * from "SYSTEM". "QRQC_TRACK_REPORT"
where PROPOS_DATE between '${datedelta(format(para1,"yyyy-MM-dd"),-7)}'
and '${para1}'
and rowid in(select max(rowid) from "SYSTEM". "QRQC_TRACK_REPORT"
group by ID01)
order by PROPOS_DATE desc
改成你的字段与参数名称
加7天的sql要如下:
select * from "SYSTEM". "QRQC_TRACK_REPORT"
where PROPOS_DATE between '${para1}'
and '${datedelta(format(para1,"yyyy-MM-dd"),7)}'
and rowid in(select max(rowid) from "SYSTEM". "QRQC_TRACK_REPORT"
group by ID01)
order by PROPOS_DATE desc