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.