javascript + reportparameter

birtprofi

<strong class='bbc'>Hi guys,<br />
<br />
I use following DataSet - Property Binding:</strong><br />
<br />
if (params["Abteilung"].equals("*")) {<br />
this.queryText = "select distinct e.EIG_DP from EIG e where e.EIG_DATUM between '2011-01-01' and '2011-08-31'";<br />
} else {<br />
var endOfQuery = "";<br />
this.queryText = "select distinct e.EIG_DP from EIG e where <span class='bbc_underline'>e.ORGDATA_ID IN ( " + params["Abteilung"] +")</span> and e.EIG_DATUM between '2011-01-01' and '2011-08-31'" + endOfQuery;<br />
}<br />
<br />
<strong class='bbc'>The Report Parameter "Abteilung" is a List Report Parameter as String and allow multiple values.<br />
If I use the script above I got following error:</strong><br />
<br />
Table (id = 4748): <br />
+ Cannot get the result set metadata.<br />
org.eclipse.birt.report.data.oda.jdbc.JDBCException: SQL statement does not return a ResultSet object.<br />
SQL error #1:Unclosed quotation mark after the character string 'Ljava.lang.Object;@6d0c52a2) and e.EIG_DATUM between '2011-01-01' and '2011-08-31''.<br />
;<br />
com.microsoft.sqlserver.jdbc.SQLServerException: Unclosed quotation mark after the character string 'Ljava.lang.Object;@6d0c52a2) and e.EIG_DATUM between '2011-01-01' and '2011-08-31''. (Element ID:4748) <br />
<br />
<br />
<strong class='bbc'>If I print the report parameter I got following:</strong><br />
[0, 6, 7, 9, 10, 11]<br />
<br />
The right sql should be: ....e.ORGDATA_ID IN (0, 6, 7, 9, 10, 11)[/u<br />
<br />
<strong class='bbc'>I guess the failure is the quotation mark .... e.ORGDATA_ID in (".....") But without this it seems the java script syntax is wrong.<br />
<br />
So I am not a javascript specialist, please give me your advise.<br />
<br />
best regards.<br />
<br />
Rafael</strong>

johnw

You want something like:

var x = 0;
var tempString = "";
var objectArray = params["NewParameter1"].value;

for (x = 0; x < objectArray.length; x++)
{
if (x > 0)
{
tempString = tempString + ", ";
}
tempString = tempString + "\"" + objectArray[x] + "\"";
}

tempString;

If you don't need the quotes around each value, you can get away with params["YourParameter"].toString();