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