需求：报表的参数块中，有很多条件。目前想分为两类；A类有值就按照A条件查询。否则按照B类。 具体：工号有值是按照工号查询。否则按照四级部门查询。 目前：数据条件 where 工号 is not null ${if(len(dpt01)=0,""," and mix.单位 = ' "+dpt01+"'")} ${if(len(dpt02)=0,""," and mix.一级部门= ' "+dpt02+"'")} ${if(len(dpt03)=0,""," and mix.二级部门= ' "+dpt03+"'")} ${if(len(dpt04)=0,""," and mix.三级部门= ' "+dpt04+"'")} ${if(len(dpt05)=0,""," and mix.四级部门= ' "+dpt05+"'")}
界面：
|
1min目标场景问卷
立即参与
