How to retrieve all queue_members of a queue using SOQL query

Question

How to retrieve all  queue_members of a queue using SOQL query

Ayush Gupta · Answer

Hi Ranganath,

[Select Id from Group where type='Queue' and Name='Queue Name']

Queues are stored as records in the table Group with 'Type' as "Queue". Use this Id of the queue in the query

[Select UserOrGroupId From GroupMember where GroupId =:reqdGroupId]

to fetch all the users or groups which are members of the required queue.

Salesforce Developer