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
Query Editor
Migrateduser
I have a doubt the way Query Editor works. It seems we cannot able to call multiple queries through the script.
Please find the attached rptdesign.
I tried the folowing cases:
====in script 'beforeOpen'======
qt = "select * from RPT_ASSET_REQUEST_36";
qt1 = "select * from RPT_ASSET_REQUEST_36 ";
this.queryText = this.queryText.replace("scriptSelect",qt).replace("scriptSelect",qt);
this.queryText = this.queryText.replace("scriptSelect1",qt1).replace("scriptSelect1",qt1);
=====in dataset Sql Query editor I used the following===========
Case 1: scriptSelect --> Working
Case 2: scriptSelect UNION ALL scriptSelect --> Working
Case 3: scriptSelect UNION ALL scriptSelect1 --> Not Working
Please correct me if I am wrong.
Thanks
AR
Find more posts tagged with
Comments
There are no comments yet