I appreciate all the replies buy my issue is not dynamically adding one or more approvers to a single Approval workflow activity. What I'm looking for is a way to dynamically add sequential approvals. That is, approval #1 must be approved before approval #2 is sent, and #2 must be approved before #3 is sent and so on. The key is the number of approvals must be dynamic, for example, one request may only require 2 approvals whereas another request may require four approvals - again, in sequence not in parallel.
So I turned to a ServiceNow friend, Dave (Super Dave) Knight and he pointed me to the ServiceNow Document Management Application (requires a plugin activation) which already has this dynamic sequential approval feature in place.
Here's how it works (courtesy of Super Dave):
There is a list of approvers at the bottom of the form, arbitrary length. There is also a field on each approver called 'Sequence'. If you are #1, you approve first. If you are #2, second, and so on. Better yet, if two people are at #2, they approve in parallel, after #1 approvers, and before #3. You get the picture.
There is a workflow built to handle that. It is designed to iterate approvals through that list. It is called 'Document Management Default', illustrated below. It uses a standard Approval activity (scripted of course), and a loop. I've included the code in the key activities marked 1, 2 and 3 below (in case you do not have the document management plugin installed).
Activity #1 (Run Script): Basically goes to the list of records in the DB and remembers the who and sequence number for each value in RAM (the scratchpad). The code that gets the list out of the DB is in DocumentManagementDB, but as you will see, all it does is create an array of approvers, where each object has the name and sequence number of the approver.
current.approval = 'requested';
var db = new DocumentManagementDB();
var approvers = db.getApprovers(current.document);
workflow.scratchpad.approvers = approvers;
if(approvers.length>0){
workflow.scratchpad.current_sequence = approvers[0].sequence;
} else {
workflow.scratchpad.current_sequence = 0;
}
Activity #2 (Approval — User, Additional approvers script): This just gets the array of all approvers at the current sequence number …
answer = [];
var currentSequence = workflow.scratchpad.current_sequence;
var approvers = workflow.scratchpad.approvers;
for(var i=0; i<approvers.length; i++){
if(approvers[i].sequence == currentSequence) {
if(approvers[i].user){
answer.push(approvers[i].user);
} else {
answer.push(approvers[i].group);
}
}
}
Activty #3 (If, Script):
answer = isThereANextSequence();
function isThereANextSequence() {
var currentSequence = workflow.scratchpad.current_sequence;
var approvers = workflow.scratchpad.approvers;
var nextSequence = getNextSequence(approvers, currentSequence);
if (nextSequence>0) {
workflow.scratchpad.current_sequence = parseInt(nextSequence);
return 'yes';
}
return 'no';
}
function getNextSequence(approvers, currentSequence){
for(var i=0; i<approvers.length; i++){
if(approvers[i].sequence>currentSequence){
return approvers[i].sequence;
}
}
//We went through all the sequences
return 0;
}
I know I'm going to find many uses for this functionality and I hope others find it useful as well.
Once again, many, many thanks to Dave Knight for this information.
Michael
