BO Query Builder

[naveen_kumar29091984]

Hello

I am trying to achieve below JPEG output using query builder,I am using below query ,Is there any way,I can get the output within a single query?

To get all reports used by universe(UNX)--4.X

SELECT SI_NAME FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS WHERE PARENTS("SI_NAME='Document-DSL.Universe'","SI_NAME ='eFashion.unx'")

--------------------------------------------------------------------------------------------

To get all reports used by universe(UNV)—3.X

SELECT SI_NAME FROM CI_INFOOBJECTS, CI_SYSTEMOBJECTS, CI_APPOBJECTS WHERE PARENTS("SI_NAME='WEBI-UNIVERSE'","SI_NAME ='EFASHION'")

-------------------------------------------------------------------------------------------

To get all UNV Universe in 3.0 SELECT SI_NAME FROM CI_APPOBJECTS WHERE SI_KIND='UNIVERSE'

--------------------------------------------------------------------------------------

To get all UNX Universe in 4.0

select SI_NAME from ci_appobjects where SI_SPECIFIC_KIND='DSL.Universe'

capture.jpg

[Joe_Peters · Accepted solution]

No, unfortunately.

The CMS query syntax is "SQL-ish". It doesn't support left joins or group bys, which would be necessary to produce the result you're trying to get.

[naveen_kumar29091984 · Accepted solution]

Many Thanks for your Input Joe.