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

Jaspersoft Community 'Read-Only' as of July 8, 2022

Transition to New TIBCO Community Just Weeks Away

You can still search, review wiki content, and review discussions in read-only mode. Please email community@tibco.com with questions or issues requiring TIBCO review or response.

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: 4 years 3 months ago

@Shazia , 

 

Thanks for your answer. 

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

vaibhav_jain_ - 4 years 10 months ago

1 Answer:

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
198
Joined: Aug 2 2017 - 6:08am
Last seen: 3 years 1 month ago
Feedback