您好,经过我们这边多方面的测试终于找到了在该数据库多值传参的解决办法:
解决思路如下:我的测试数据库为Test2,自己在Postgresql里建了一个命名为Test2的表,参数为p1
(1)脚本 Function ArrayToString(list As Object()) As String Dim re ="" For Each item AsString In list If item IsNothing Then ContinueFor End If
If re<> "" Then re +="," End If
re += item Next Return re End Function (2)数据集SQL使用表达式 ="select *from Test2 WHERE 业务编号 In ('" +Join(Split(Code.ArrayToString( Parameters!P1.Value ), ","), "','") + "')"
|