Using the "in" parameter in BIRT

Hello,

I would like to pass as a parameter the value to be used inside the SQL of the DataSet

for example:

"select * from users where userId in (?)"

I would like "?" to be '12,13,14'

How can I do this with BIRT ?

Find more posts tagged with

Comments

mwilliams

Hi hq4ever, 
 
Take a look at this post from the devShare: 
 
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/535-using-in-like-clause-in-birt/#'>Using IN/LIKE Clause in BIRT - Tutorials - BIRT Exchange</a>

hq4ever

<blockquote class='ipsBlockquote' data-author="mwilliams">Hi hq4ever, 
 
Take a look at this post from the devShare: 
 
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/535-using-in-like-clause-in-birt/#'>Using IN/LIKE Clause in BIRT - Tutorials - BIRT Exchange</a></blockquote>
 
This is great, you've collected the most common questions into article and now you just reference to them. 
 
I think that your next step should be expending the accessibility to this information because I did searched for the 'in' parameters in Google and found irrelevant content, thus the question in these forums. 
 
Anyhow - Thank you very much !

mwilliams

hq4ever,

Searching our site directly in the forums or devShare may be more worth your time than just a google search in some cases.