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
Pulling datarow from outer dataset
Migrateduser
In one of my reports there is a section that goes 3 dataSets & Tables Deep.
mainDataSet --> taskDataSet --> workDataSet
In my sql query in workDataSet, I need specific rows from the other DS. For mainDataSet I used row[0]["dataFromMain"] and it pulls the correct data. For taskDataSet I've hit a wall. I've tried multiple things and haven't gotten anything to work correctly.
I know my query is fine, because if I hard-code in specific task #'s everything runs as it should, with correct data.
my latest attempt used row._outer["dataFromTask"]. This did not work.
essentially:
Select data,data1,data2 from tables where maindata = row[0]["dataFromMain"] and taskdata = ???["dataFromTask"]
Any help you have would be most welcome.
Find more posts tagged with
Comments
There are no comments yet