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

Posted on August 29, 2017 at 5:15am
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? 

JasperReports® Server
Jaspersoft® Studio
vaibhav_jain_'s picture
vaibhav_jain_
3
Joined: Aug 11 2017 - 7:22am
Last seen: 2 years 4 months ago

@Shazia , 

 

Thanks for your answer. 

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

vaibhav_jain_ - 2 years 11 months ago
add comment

1 Answer:

1
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. 

Shazia's picture
Shazia
22
Joined: Aug 2 2017 - 6:08am
Last seen: 1 year 2 months ago
Feedback