How to close request item when all it's tasks are closed

dp11
Tera Guru

Hi,

I have a workflow on requested item table that creates a single catalog task. When this task closes, the item closes as expected. But when users

have added new catalog tasks outside of the WF using the New button, the requested item does not close after all it's tasks are closed. Any idea

how this can be achieved? I have put a 'Wait for Condition' that has the following code, but that doesn't seem to be helping:

checkTask();

function checkTask() {

var task_cnt = 0;

var closed_tasks = 0;

var catalog_task = new GlideRecord('sc_task');

catalog_task.addQuery('request_item',current.sys_id);

catalog_task.query();

task_cnt = catalog_task.getRowCount();

      while(catalog_task.next()){

              // We are checking, whether the state of task   is closed, so "3" is the database value of closed complete state,

              // "4" is closed incomplete and "7" is closed skipped    

              if(catalog_task.state == "3" || catalog_task.state == "4" || catalog_task.state == "7") {

                      closed_tasks = closed_tasks + 1;

              }

      }

      if( closed_tasks == task_cnt)

      {

            answer = true;

      }

}

Thanks,

Debashree

1 ACCEPTED SOLUTION

manikorada
ServiceNow Employee
ServiceNow Employee

Debashree,



The issue here is whenever the Workflow created task is closed then there will be a business rule which will run and invoke the Workflow on RITM. You need to have similarly for Manually created Tasks.


So, have a Business Rule on sc_task something like this:


Name: Invoke Workflow On RITM


When : onAfter


Order: 800


Condition : current.wf_activity.nil() && (current.state.changesTo(3) || current.state.changesTo(4) || current.state.changesTo(7))


Script:



// Run any workflow(s) so this task's state changes can be checked


runWorkflow_task();




function runWorkflow_task() {


    if (!current.request_item.nil()) {


          var gr = new GlideRecord('sc_req_item');


          gr.addQuery("sys_id",current.request_item.toString());


          gr.query();


          if (gr.next()) {


          new Workflow().broadcastEventToCurrentsContexts(gr, 'update', null);


          }


    }


}


View solution in original post

28 REPLIES 28

manikorada
ServiceNow Employee
ServiceNow Employee

Debashree,



Try the code something like:



answer = checkTask();


function checkTask() {


var res = true;


var catalog_task = new GlideRecord('sc_task');


catalog_task.addQuery('request_item',current.sys_id);


catalog_task.addQuery('active',true);


catalog_task.query();


if(catalog_task.next()){


        res = false;


}


return res;


}


Hi Mani,


I tried your code but that didn't work either


Any other ideas?


Thanks,


Debashree


manikorada
ServiceNow Employee
ServiceNow Employee

Hi Debashree,



Can you provide your workflow screenshot and also tell us what are the steps you are following and where it is failing?


I submit a request and get it approved. This creates one task automatically based on the WF. After this I go to the RITM view and at the bottom where the tasks are listed, I use the New button and add a manual task. Then I close both the tasks. But RITM still in stage 'Work in Progress'. Below are snapshots of the workflow, the task list, and the workflow execution stage after tasks are closed:



Capture1.PNG


Capture2.PNGCapture3.PNG


Thanks,


Debashree