Report - Nested Queries - Accessing variables thru scripting

[Elling_Aarseth]

Hi!

We're looking into using the Report Module, but need a clarification.

We are using nested Queries to structure some data. In addition to that we want to create a custom script that accesses some of the information from the nested query and adds parameters to the nested query result.

This is how the nested query is organized:

Spesific question:

1. How do we access the "start_time" in the "Site"
2. How can we add a dataset to the "Site"

Thanks for all help

[pturmel]

See this (old) topic:

Report with Scripted Nested Data

The report datasource scripting examples explain how to access the nested data in another key for use constructing a custom dataset. What I don’t see is how to construct nested data that would be suitable for use with a child table in a table group. I have a parent dataset that I’m constructing via script due to annoying limitations of an ancient SQL Server 2000 instance. I need a subquery for each row that could be done with a normal query, but there’s no way to add a regular subquery to a s…

[Elling_Aarseth]

Hey, and thanks for your very quick reply!

i have already looked through this thread a couple of times.
Have tried the "addNestedQueryResults", and it seems to work great.

But i still haven't found an answer on how to access "start-time" from the "site" level in the nested query structure. in a script. Do you have a good tip on how to solve that?

[pturmel]

data['trip'] is the outer QueryResult. Use .getCoreResults() on that to get its Dataset, and the rows thereof.