Query to get InfoObject(ReportObject) from specific Folder

86 Views

Hi,

I am using XI Release 2.I am having one report object in two folders with the same name.

example: I am having one report object named TestReport that exist in folder ALL as well as folder TEMPORARY in CMS.

Following query i am using:

"SELECT TOP 1 * FROM CI_INFOOBJECTS WHERE SI_PROGID = 'CrystalEnterprise.Report'").append(" AND SI_INSTANCE=0 AND SI_NAME='").append(TestReport ).append("'");

but it always returns the report object from folder ALL while i want to have report Object from folder TEMPORARY

Reporrt Path: path://InfoObjects/Root Folder/Temporary/

Can anyone help me out with the query to get the report object from specific folder?

Thanks

Prakhar Paharia

Edited by: prakhar paharia on Mar 10, 2009 3:43 PM

Edited by: prakhar paharia on Mar 10, 2009 3:44 PM

Edited by: prakhar paharia on Mar 10, 2009 4:17 PM