Skip to Content
0
Jan 10, 2019 at 06:05 AM

Querying Users of all Groups

69 Views Last edit Jan 10, 2019 at 12:47 PM 5 rev

I trying to query users of all groups in business objects.

SELECT *
FROM ci_systemobjects 
WHERE descendants("si_name='Usergroup-User'", "si_name='<group name>'")

The above query will return users of one group. But, I want users of all groups with group name in the below format.

User_id group_name

Thanks and Regards,

Diwakar G