Using a Multivalue parameter in a in clause

Migrateduser

This is a sightly different (and simpler IMHO) than this post:<br />
<br />
http://www.birt-exchange.com/devshare/designing-birt-reports/688-using-a-multivalue-parameter-in-an-in-clause/#description<br />
<br />
In my query I have something like this:

where PRODUCTLINE in ('****')

<br />
and in my beforeOpen Script:

this.queryText = this.queryText.replace("****", params["pProductLines"].value.join("','" ));

<br />
Note the separator of the join function - ',' (single quote, comma, single quote). Attached is a sample using this technique.