This is a really interesting problem.
Here's how I'd do that.
Setup: create a "Reopened" checkbox on the sc_item table
We need to capture the sequencing of tasks, which one(s) have been reopened, and where to reopen from.
1. Set up some workflow.scratchpad variables (see the Run Script activity from the workflow):
if (typeof workflow.scratchpad.taskArr == 'undefined'){
workflow.scratchpad.taskArr = [];
}
if (typeof workflow.scratchpad.resetFrom == 'undefined'){
workflow.scratchpad.resetFrom = '';
}
2. Create "IF" conditions ahead of every task creation. Advanced script (will have to be unique for every task, but I tried to make it as easy as possible--just change line 3):
answer = resetFrom();
function resetFrom(){
var taskOrderNumber = 1;
// return "yes" if we haven't created the next task yet
// (i.e. haven't yet progressed to this point)
if (workflow.scratchpad.taskArr.length < taskOrderNumber){
return "yes";
}
// check to see if we should reset from here
// delete the additional elements of the array to ensure reopen
if (workflow.scratchpad.taskArr[taskOrderNumber - 1] == workflow.scratchpad.resetFrom){
workflow.scratchpad.taskArr.splice(taskOrderNumber, taskOrderNumber - workflow.scratchpad.taskArr.length);
return "yes";
}
return "no";
}
3. In each and every task creation, set the fields:
- Reopened = false
- Order to "100," "200," etc. for each task in sequence
- in the "Advanced" script, put this
if (task.sys_id == ''){
workflow.scratchpad.taskArr.push(task.setNewGuid() + '');
}
else {
workflow.scratchpad.taskArr.push(task.sys_id + '');
}
4. Create a "Wait for condition" to look for reopened tasks
answer = hasReopenedTask();
function hasReopenedTask(){
var scTaskGR = new GlideRecord('sc_task');
scTaskGR.addQuery('req_item', current.sys_id);
scTaskGR.orderBy('order');
scTaskGR.query();
while(scTaskGR.next()){
if (scTaskGR.u_reopened == true && scTaskGR.hasNext()){
scTaskGR.next();
workflow.scratchpad.resetFrom = scTaskGR.sys_id + '';
return true;
}
}
return false;
}
5. Rollback to the beginning and the "IF" activities should take care of the rest.
