Order that queries are run

building reports desktopintelligence
1

v6.5, Oracle

Is there any easy way to change the order that queries are run in a report? Meaning - Ive build query 1 and then built query 2 but I should have built 2 first because query 1 uses a condition “In List of the Query 2 Results”

Or does it matter?

Thanks

Dave

Westy (BOB member since 2004-09-02)

2

Hi,

No, there is no way how to change the order in which queries are refreshed in the report.

However, BO is smart enough to recognize that your query 1 depends on the results of the query 2 because you use “In List of the Query 2 Results”. In such a case (and only in this case) BO automatically runs query 2 first and then query 1. So you do not need to be worried.

Marek Chladny :slovakia: (BOB member since 2003-11-27)

3

Thanks Marek - appreciate the help.

Westy (BOB member since 2004-09-02)