<p>Hi,</p>
<p> </p>
<p>After going through several posts related to passing multiple values on a single parameter, i wrote my sql in the BIRT dataset as <span style="color:#ff0000;">select m.country,tp.categoryLev1 ,tp.categoryLev2,m.sentiment,<br>
(case when m.sentiment=1 then 'S1' when m.sentiment=2 then 'S2'<br>
when m.sentiment=3 then 'S3' when m.sentiment=4 then 'S4' end) as rating<br>
from mentionmysql.topic tp<br>
join mentionmysql.master m on m._id=tp._id<br>
where m.Country like ? and </span><span style="color:#0000ff;">tp.categoryLev1 IN ('****')</span><br><span style="color:#ff0000;">and m.MentionCreatedDate between str_to_date(?,'%d/%m/%Y') and str_to_date(?,'%d/%m/%Y');</span><br>
and wrote the script for before open for the same dataset as ,</p>
<p> </p>
<p><span style="color:#ff0000;">this.queryText = this.queryText.replace("****", params["CategoryLev1"].value.join(","));</span></p>
<p> </p>
<p>Yet i did not get any positive result.</p>
<p>FYI I use spagobi studio (Eclipse Platform Version: Luna SR2 (4.4.2)) for creating BIRT report.</p>
<p> </p>
<p>My parameter name is <span style="color:#0000ff;">CategoryLev1</span>. All parameters are defined as text box so that I can configure these parameters as list box on spagobi server.</p>
<p> </p>
<p>can anyone help me out. Thanks</p>
