CMS Self Join

[arno_huerlimann56]

If I want to know, which webi-Document has a Folder as Parent Object, I can do this directly with a SQL to the CMS Database.

Select p.ObjectID Ordner_ObjectID, o.ObjectID Web_ObjectID, p.ParentID, o.TypeID Typ344Webi, p.TypeID Typ1Folder, p.OwnerID, p.Version, CAST(p.SI_CUID AS VARCHAR(MAX)) Ordner_SI_CUID, CAST(o.SI_CUID AS VARCHAR(MAX)) WebID_SI_CUID from CMS_InfoObjects7 o <br>Join CMS_InfoObjects7 p ON p.ObjectID = o.ParentID<br>where<br>o.TypeID = 344 And p.TypeID = 1;

This one does not work:

Select p.si_cuid, o.si_cuid, p.si_parentid, o.si_kind, p.si_kind, p.si_owner, p.si_cuid
From Properties o 
Join Properties p ON p.si_cuid = o.si_parentid
where o.si_kind = 'Webi' And p.si_kind = 'Folder';

Does anyone know how I can do this in a WEBI-Document, maybe with FHSQL? I couldn't not find how to "self-Join" the Database.

[JohnClark]

Most of the data in the CMS database is encrypted and you won't be able to query it directly.

Try the BI platform CMS system database.unx universe that comes with Business Objects now.

[arno_huerlimann56]

That is exactly what I am trying... FHSQL in a webi document: