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.