Error after adding a new where clause in Java script

<p>Hi,</p>
<p> </p>
<p>I am new to Birt reporting. I updated the script with a new where clause that will check the Input parameter selected. But it returns error when the report is generated. </p>
<p> </p>
<p>Below is the new where clause added to the existing script</p>
<p> </p>
<div>whereClauseTmp = "";</div>
<div>var organization = params["RP_Organization"].value;</div>
<div>if ( organization != -100 )</div>
<div>{</div>
<div> whereClauseTmp = " AND nrb.CURRENT_PROVIDER = '" + params["RP_Organization"].value + "' ";</div>
<div> whereClause = whereClause + whereClauseTmp;</div>
<div>}</div>
<div> </div>
<div>Can someone help to solve this

Find more posts tagged with

Comments

sureshpulapalli

<p>Get the final query from report and test this using any client tool. If the issue is with query,this way you can fix it quickly.</p>