怎么解决这种问题,想要接收的年份自动减去一年,目前得出的结果是这样的 and t1.year in ('2025'-1)
下面附上参数: if((年份 - 1)<= 2022, "and t1.YEAR = " + (年份 - 1) + " and t1.status in (2, 4)", "and t1.YEAR = " + (年份 - 1) ) )} ${if(len(上报状态) == 0 || (年份 - 1) <= 2022,"", "and t1.status in ('" + replace(上报状态,",","','") + "')" )} |