Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 25 at 10:41 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 25 at 10:45 AM
    Add comment
    10|10000 characters needed characters exceeded

  • Feb 25 at 10:46 AM
    Add comment
    10|10000 characters needed characters exceeded