| 各位大神好 我现在有个需求是根据选择的省市县去合计两个数值，如果只选择省这个参数就按照省为单位合计，选择省和市就按照省+市来合计，省市县都选择的话，合计维度精确到县。代码中在where语句里面做了多选的限制，用的in 但是关于市和县这里做限制的时候代码写上就报错。。。求大神帮忙看看问题所在。。谢谢 代码如下： select ${if(len(省)=0,"","sheng")} ${if(len(市)=0,"",",shi")} ${if(len(县)=0,"",",xian")}, sum(hryongliang), sum(mzyl) from(select (select enum_item.showvalue from ctp_enum_item enum_item where enum_item.id = formmain_3840.field0001) sheng, field0002 shi,field0003 xian,field0008 mzyl,field0041 hryongliang from formmain_3840) where 1=1 and sheng in('${省}') ${if(len(市)=0,"","and shi in ('${市}')")}-------------------------------------------------这两行写上就报错 ${if(len(县)=0,"","and xian in ('${县}')")}-----------------------------------------------这两行写上就报错 group by ${if(len(省)=0,"","sheng")} ${if(len(市)=0,"",",shi")} ${if(len(县)=0,"",",xian")} |
