You need to sign in to do that
Don't have an account?
Nandakumar Sakthivel
Need a report on the list of users and their public group association
Hi All ,
Need a report on the list of users and their public group association.
SELECT Email,FirstName,LastName From User Where ID in (SELECT UserOrGroupId From GroupMember Where Group.type='Regular')
I am not sure about how to fetch group name as part of the above query, Is there a way to fetch these details in any approach ? The result should be in the below format,
Email 1 , First Name 1 , Last Name 1 , 'Group 1' , 'Group 2'
Email 2 , First Name 2 , Last Name 2 , 'Group 3' , 'Group 2'
Thank you
Need a report on the list of users and their public group association.
SELECT Email,FirstName,LastName From User Where ID in (SELECT UserOrGroupId From GroupMember Where Group.type='Regular')
I am not sure about how to fetch group name as part of the above query, Is there a way to fetch these details in any approach ? The result should be in the below format,
Email 1 , First Name 1 , Last Name 1 , 'Group 1' , 'Group 2'
Email 2 , First Name 2 , Last Name 2 , 'Group 3' , 'Group 2'
Thank you