Workflow Approvals: Duplicate Approvals control

[gfficom]

Hi

I have a series of HR Workflows with multiple sequential approvals that kick off at different points in the process. In some cases an earlier Approval has the same Approver as a later one.
eg

1st Approval to Users Manager Joe Smith (Workflow looks for 'Manager' and finds Joe Smith)
then moves on to 😆
2nd Approval to HR Admin Bill Smith
then moves on to:>
3rd Approval Dept Head who is Joe Smith (Workflow looks for Dept Head who is also 'Joe Smith')

I only need Joe Smiths approval once

I am looking for a way to control the volume Approval requests going to an individual who had already approved the request at an earlier stage.

All help appreciated.

Regards

Gerry Fitzpatrick
Intelinet Dublin Ireland

[Dan Tolgyesi1]

Hi Gerry,

I also have this requirement to meet IT General Controls, have you been successful at all?

Regards

Dan Tolgyesi
Admin Re, Telford

[gfficom]

Hi

Thanks for the input.

We are going to try this Before insert business rule. One of our guys came up with this. I am about to test it I will let you know how i get on.
Cheers

Gerry


//gs.log("*****INSIDE");
//gs.log("***** Current: "+ current.approver);
var gr = new GlideRecord('sysapproval_approver'); //Indicate the table to query from

gr.addQuery('sysapproval', current.sysapproval);
gr.addQuery('approver', current.approver);
gr.addQuery('state', 'approved');
gr.query(); //Execute the query
if (gr.next()) { //While the recordset contains records, iterate through them
//Do something with the records returned
//gs.addInfoMessage("RECORD SUBMISSION ABORTED: "+ current.sys_id);
//current.setAbortAction(true);
current.state='not_required';
}

[cornflakes_01]

If the process isn't too big, the simplest solution I can think of would be to do a check before each of the approval activities to say "If the HR Admin is equal to the user's manager, skip that approval and move on". then on subsequent approvals, continue in a similar fashion, but include all of the if statements that you made in approvals prior to that new approval activity.

[Dan Tolgyesi1]

Thanks for your suggestion on the If statement, I have explored this route

My requirements differ slightly from this, the first approval on my workflow is a line manager approval and the second is a higher approval group which in some cases the line manager is also in but is not alowed to approve as this must have 2 different approvers on record.

I am trying to create a 'before insert' business rule on the sysapproval_approver table which queries the RITM number and searchers the approver field for duplicates so it can abort that record, its not working yet but hopefully I can get there.

Thanks
Dan