How to pass all the values of a collection parameter one by one in query?
Posted on August 29, 2017 at 5:15am
So,
Is it possibe to that? Where I have parameter p1 which is a colection of strings and I pass it like an array or a list like p1(0) , p1(1) . and so on? Are there any alternatives to that?
I cannot use a where clause here, I think, because I am using JSON post as query, so I will pass all the values of the parameter. IF we can do that, how do I load that parameter? BY an input control?
Joined: Aug 11 2017 - 7:22am
Last seen: 1 year 5 months ago
Posted on August 29, 2017 at 6:50am
Use the below in your query where clause -
where
$X{IN, DBField ,CollectionParameter}
I have been using this since long, works fine.
Joined: Aug 2 2017 - 6:08am
Last seen: 3 months 2 weeks ago
@Shazia ,
Thanks for your answer.
How do I encorporate the IN clause in a JSON query?