Skip to Content
0

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

Feb 23 at 03:16 PM

52

avatar image
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

SQL
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Bharath B N
Feb 25 at 10:41 AM
1

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.

Share
10 |10000 characters needed characters left characters exceeded
Bharath B N
Feb 25 at 10:45 AM
1
Share
10 |10000 characters needed characters left characters exceeded
Bharath B N
Feb 25 at 10:46 AM
1
Share
10 |10000 characters needed characters left characters exceeded