Skip to Content
0
Former Member
Oct 16, 2012 at 07:34 PM

Query to list all Shceduled reports in a folder

1460 Views

Hello,

I am facing challenges in building a query using Query Builder to return scheduled reports in a folder.

I have a folder, say A which has sub folders in it. I would like to build a query to return all the scheduled reports belong to Folder A.

I could build a query but for that i had to get SI_ID of all the sub folders. Is thsi the only way i can do? I would like to use SI_ID of folder A only to get the required data. Can i do that? If yes. How can i do that?

Following is the query i could create:

Select SI_NAME,SI_SCHEDULEINFO.SI_STARTTIME,SI_SCHEDULEINFO.SI_ENDTIME from CI_INFOOBJECTS where SI_PARENTID IN (SI_IDs of all the sub folders) AND SI_KIND='CrsyatlReport'

Please suggest me on this.

Best Regards,

Sastry