Joining Of query in Script

LokeshP

Hello team,

I have designed one report in which we have one dataset and one dropdown.

Dropdown values are "All , Windows , Linux, Unix".

I have created one dataset Thrshold. In which i have written a query "select * from Windows".

Now in before open event of data set i am replacing table name by choice of selection in dropdown.

if(param["Drop Down"]== linux)
{
this.queryText= this.queryText.replace("windows" , "Linux");
}

and this working fine all because windows and linux and unix tables are identical in terms of columns and datatypes.


Now in case of "all" i want union of output of all three tables.
but its not working.

I have Done in such a way.

if(param["Drop Down"]== All)
{
this.queryText_win= this.queryText.replace("windows" , "Windows");
this.queryText_lx= this.queryText.replace("windows" , "Linux");
this.queryText_ux= this.queryText.replace("windows" , "Unix");

this.queryText = this.queryText_win + " Union all " + this.queryText_lx + " Union All "+ this.queryText_ux;


}

but this is not generating out put it is giving error.

Thanks in Advance.

Hans_vd

Does it work when you write it like this:<br />
<br />
<pre class='_prettyXprint _lang-auto _linenums:0'>if(param["Drop Down"]== "All")
{
queryText_win= this.queryText.replace("windows" , "Windows");
queryText_lx= this.queryText.replace("windows" , "Linux");
queryText_ux= this.queryText.replace("windows" , "Unix");

this.queryText = queryText_win + " Union all " + queryText_lx + " Union All "+ queryText_ux;
}</pre>