Equivalent of IN operator in BIRT

bobj123

Hi Everbody,

What's the equivalent of IN operator in BIRT if I want to pass three values like where empno in (1,2,3).

mwilliams

Hi bobj123,<br />
<br />
If you're writing it straight in the query like that, you'd just use the IN operator. If you're using a multi-select parameter, here's a couple examples that should help with that:<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/771-using-a-multivalue-parameter-in-a-in-clause/#description'>Using a Multivalue parameter in a in clause - Designs & Code - BIRT Exchange</a><br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/688-using-a-multivalue-parameter-in-an-in-clause/#description'>Using a multivalue parameter in an in clause - Designs & Code - BIRT Exchange</a>