报表复选框多选查询

大佬们，报表做了复选框多选查询，返回值类型选的字符串，分隔符是逗号，然后报错：错误代码:11300001 数据集配置错误“(研发中心,研发部,电气软件部,设计部)”附近有语法错误。

数据集里的sql是这么写的：{if(len(comboCheckBox_department_name)==0,"","AND SUBSTRING(SUBSTRING(TR.EmployeeName, CHARINDEX('-', TR.EmployeeName) + 1, LEN(TR.EmployeeName)),1,CHARINDEX('-',SUBSTRING(TR.EmployeeName, CHARINDEX('-', TR.EmployeeName) + 1, LEN(TR.EmployeeName)))-0.5) in'"+'('+comboCheckBox_department_name+')'+"'")}

in后面正常应该是("xxx","xxx","xxx","xxx"),现在变成了"(xxx,xxx,xxx)"这种形式了，怎么修改

被迫营业的小白 发布于 2024-7-23 10:47

1min目标场景问卷

立即参与

回答问题关注问题

悬赏：0 F币 + 添加悬赏

提示：增加悬赏、完善问题、追问等操作，可使您的问题被置顶，并向所有关注者发送通知

共4回答

最佳回答

小菜鸡222Lv4见习互助
发布于2024-7-23 11:02（编辑于 2024-7-23 11:04）

in ('"+XXX+"') 我看你似乎括号没放对

snrtuemcLv8专家互助
发布于2024-7-23 10:49

${if(len(comboCheckBox_department_name)==0,"","AND SUBSTRING(SUBSTRING(TR.EmployeeName, CHARINDEX('-', TR.EmployeeName) + 1, LEN(TR.EmployeeName)),1,CHARINDEX('-',SUBSTRING(TR.EmployeeName, CHARINDEX('-', TR.EmployeeName) + 1, LEN(TR.EmployeeName)))-0.5) in '"+'('+replace(comboCheckBox_department_name,",","','")+')'+"'")}