Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
Joining Of query in Script
Migrateduser
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.
Find more posts tagged with
Comments
There are no comments yet