how to find the approvals that are set to an support queue (approval group)

[satya kasina]

how to find the approvals that are set to an support queue (approval group) ?

[Bhuvan · Accepted solution]

@satya kasina 

Check below tables to see if you are looking for this information

sysapproval_group

sysapproval_approver

If this helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[vignesh parthib]

Hi Satya,

You can check it in table 'sysapproval_approver'

If you try using script then try using  below script:

var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('group', '<support_queue_sys_id>');
gr.addQuery('state', 'requested'); // or whatever state you want to filter
gr.query();
while (gr.next()) {
      gs.info('Approval for: ' + gr.document_number + ' assigned to group: ' + gr.group.getDisplayValue());
}

[svirkar420]

Hi @satya kasina , 

To find approvals that are set to a support queue:

Open the record (like a Change, Demand, or Request).

Scroll down to the Approvals related list.

If the approval is for a group, it will show under Group Approvals (sysapproval_group).

If it’s for a user, it shows under Approvers (sysapproval_approver).

You can also search directly in sysapproval_group table to see all group approvals.

If this solution helped you Please Mark this solution as accepted and helpful as it will be helpful for other users as well.
Best Regards.
Saurabh V.