Skip to Content
0
Former Member
Feb 18, 2009 at 09:50 PM

need efficient queries to retrieve reports inside a folder

26 Views

Case 1:

******************************************************************************

To retrieve reports in a particular folder -

I am currently using 2 queries -

a) retrieving parentid given a folder name

b) retrieving all reports given the above parent id.

Can I combine these into 1 query ?

Case 2:

******************************************************************************

I also need to retrieve all reports within a given folder and subfolder. Can this be done with 1 query?

or do I need to retrieve all objects in the folder and then iterate in a loop

if folder exists and retrieve the reports.