下拉树控件和日期控件不选时显示全部数据,这个需要怎么写?两个条件单独使用时没有问题,但我放在一起时,选择了条件就报错
WHERE 1=1 ${if(len(orgidP) == "",""," and a.createOrgpath like '" + orgidP + "%'")}
and 1=1 ${if(len(NY)==0,"","where a.YEAR = '"+NY+"'")}
WHERE 1=1
${if(len(orgidP) == 0,""," and a.createOrgpath like '" + orgidP + "%'")}
${if(len(NY)==0,"","and a.YEAR = '"+NY+"'")}
http://help.finereport.com/doc-view-2394.html
where 1=1 ${if(len(NY)==0,"","and a.YEAR='"+NY+"'")}