Skip to Content
0

BO Query Builder

Jan 20, 2017 at 04:01 AM

141

avatar image

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)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Joe Peters Jan 20, 2017 at 02:01 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Many Thanks for your Input Joe.

0