Multiple parameters in a text box using oracle WHERE IN

I'm trying to figure out how to enter multiple parameters into a oracle query using WHERE IN

Select * from join1 join2
WHERE join1.id = join2.id
and join1.id in (123,456,789)

I'd also like to be able to do the same with strings if that is possible.

The set is not fixed length. How can I handle this with a web report? I am very new to BIRT, and fairly bad with Oracle SQL. I tried to set the report parameter to integer, I thought I read that it would interpolate correctly, but I can't see the output query as I do not have access to the database. Is there a way to display the compiled query in the report as dynamic text or something?

Find more posts tagged with

Comments

mwilliams

Hi greenail,

So, you'll be getting these multiple parameters from the user? Are they multiple select in a drop down? Or are they just comma separated multiple entries in a text box?

greenail

I can't do a dropdown, it needs to be user entered into a textbox. There are thousands of ID's

mwilliams

greenail,<br />
<br />
Take a look at this post from the devShare.<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/338-birt-parameters-using-in-clause/#description'>BIRT Parameters - using IN clause - Designs & Code - BIRT Exchange</a>