Question regarding a Multi select Query

I am trying to create a query using the values of an input control which allows a multi select.

Query 

SELECT
in.ref_num,

in.zaffected_org

FROM in
WHERE $X{IN, in.zaffected_org, CustomersList}

Parameter : CustomerList , Class:java.util.Collection

Input Control Query: select in.zaffected_org from in

The input control sucesfully sshows all Organizations but when i select organizations it does not pass the values into the query. 

 

I think the problem are the '' that are required in query because if i change the query to WHERE in.zaffected_org IN ('Example1','Example2') it works

 

Any ideas ????

christosloizou's picture
Joined: Nov 16 2022 - 7:17am
Last seen: 3 days 17 hours ago

0 Answers:

No answers yet
Feedback
randomness