query to find details about the usergroup and properties of the users ?

[Former Member]

I am using query builder to run my queries. I am trying to convert the details about the usergroups and users into an XML format. For that I need to find the details about properties of all Usergroups and properties of each users inside that particular group.

Now I have read about relationship queries, and when I try to run the relationship queries of usergroups and users, I do not get all information of users in it. I can only find their ID names through SI_Group_Members.

I am trying this query -

Select * From CI_SYSTEMOBJECTS Where PARENTS("SI_NAME='UserGroup-User'","SI_KIND='user'")

Is their a way to get information about both user groups and users at the same time? I tried to use union but I guess query builder does not allow Union statement

if possible I would like to get details in this format.

Group 1 - Details

--------user1 - details

--------user2 - details

--------user3 - details

Group 2 - Details

--------user1 - details

--------user2 - details

--------user3 - details

[former_member230921]

To get Query results in XML format: https://blogs.sap.com/2017/05/10/query-the-businessobjects-repository-using-bi-platform-rest-sdk-rws...

[former_member230921]

Using REST SDK:

https://help.sap.com/viewer/db6a17c0d1214fd6971de66ea0122378/4.2.5/en-US/5d75a39e198643d88349b0f16ea...

https://help.sap.com/viewer/db6a17c0d1214fd6971de66ea0122378/4.2.5/en-US/8c048fa130ef45238adcf34f5dc...

[former_member230921]

Using query builder you cannot get both User and UserGroup details as one result.

As you said - you can get only IDs and run second query to get the details of each of them.