Skip to Content

BO Query Builder

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

capture.jpg (20.2 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 20, 2017 at 02:01 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded