How to pass all the values of a collection parameter one by one in query?

0

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? 

vaibhav_jain_'s picture
Joined: Aug 11 2017 - 7:22am
Last seen: 1 year 5 months ago

@Shazia , 

 

Thanks for your answer. 

How do I encorporate the IN clause in a JSON query? 

vaibhav_jain_ - 1 year 11 months ago

1 Answer:

1

Use the below in your query where clause - 

where 
$X{IN, DBField ,CollectionParameter}

I have been using this since long, works fine. 

Shazia's picture
22
Joined: Aug 2 2017 - 6:08am
Last seen: 3 months 2 weeks ago
Feedback
randomness