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

[dp11]

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

[jmohini]

How to change the state of RITM when all tasks are completed(using Bussiness rules)?

i have created one workflow for that. when all tasks completed in workflow then state of the RITM must be show as "Closed complete".

how can i change the state using Business rules?

Thanks,

J.Mohini

[Pradeep Sharma]

Hi Debashree,

Here is the script you can write.

var task = getTask(); 

function getTask()

{

var answer = false;

var catalog_task = new GlideRecord('sc_task');

catalog_task.addQuery('active',true); //query for only active records

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

catalog_task.query();

if(catalog_task.next()){

         answer = true; //returns true if the task are not yet closed.

}

return answer;

}

[dp11]

Hi Pradeep,

I tried your code but it didn't work. Any other ideas?

Thanks,

Debashree

[p_reddi2k]

Where did the workflow stuck? Can you add some log messages in script and check if they are executing or not.

[Randall Arnold]

I know this is late, but I modified Pradeep's code in a Wait for condition as shown below, and it works flawlessly:

    var answer;
    var catalog_task = new GlideRecord('sc_task');
    catalog_task.addQuery('active', true); //query for only active records
    catalog_task.addQuery('request_item', current.sys_id); //RITM sys_id
    catalog_task.query();
    if (catalog_task.getRowCount() > 0) {
        answer = false;
    } else {
        answer = true;
    }