How to filter on Approval Group in sysapproval_approver table?

Paul125 · ‎09-10-2018

Hello, I have tried below queries but nothing seems to work. Please someone suggest me the right one. Thanks

var approvals = new GlideRecord("sysapproval_approver");
	approvals.addQuery('sysapproval', current.sys_id);
	approvals.addQuery('assignment_group', 'de7c36dedb90a3c838a5cae3b99619b4');
//also tried
       approvals.addQuery('sysapproval_group', 'de7c36dedb90a3c838a5cae3b99619b4');

Brian Lancaster · ‎09-10-2018

It looks like only individuals are put into the sysapproval_approver table and it does not seem to reference what group the are a member of directly. It looks like you would need to search sysapproval_group and get the sys_id from there of what you are looking for approvals on so you can then search for the members of that group who have rejected the request in the sysapproval_approver table. Note it only looks like the table sysapproval_group table gets populated if the workflow activity of Approval - Group is used to set the approvers. The group in the sysapproval_approver table seems to be a reference to which group was set as the approver in the sysapproval_group table. Hopefully this was not to confusing as I confused myself was I was looking at the two table and testing what populated each from the workflow.

View solution in original post

Pranav Bhagat · ‎09-10-2018

First goto that table and create a query using breadcrumbs and see whether its working or not ,if yes copy the query and use it as encoded query

gr.addEncodedQuery(str);

Regards,

Pranav

Mark my Responses as Correct and Helpful if you find it relevant.

Paul125 · ‎09-10-2018

Thanks for the reply Pranav. I tried to filter but I couldn't find the group. Please let me know if you have any idea. Thanks!

Pranav Bhagat · ‎09-10-2018

Can you please share the screenshot ,you should see the groupt,"does it have members"

Mark my Responses as Correct and Helpful if you find it relevant.

Pranav Bhagat · ‎09-10-2018

Check whether there is any reference qual on that field which might prevent it from showing

Regards

Pranav