Skip to Content
0
Dec 29, 2022 at 09:05 AM

CMS Self Join

107 Views Last edit Dec 29, 2022 at 10:22 AM 2 rev

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.