If all tasks are "closed skipped" then RITM state should be "closed skipped"

[Community Alums]

Hi All,

I have been trying hard to set the RITM state to "closed skipped" if all tasks associated to that RITM are "closed skipped"

I am using following script in If activity of workflow but it is not working, please help!

Script in If activity

answer = allCompleted();

    function allCompleted() {
        var grTask = GlideRecord('sc_task');
        var completed = 0;
        var skipped = 0;
        var count;
        grTask.addQuery('request_item', current.sys_id);
        grTask.query();

        count = grTask.getRowCount();
        while (grTask.next()) {
            if (grTask.getValue('state') === '3') {
                completed++;
            }
            if (grTask.getValue('state') === '7') {
                skipped++;
            }

        }
        if (count == completed) { 
            return complete;
        }
        if (count == skipped) { 
            return skip;
        }
        else 
            return incomplete;
    }

and if activity results configured like below

The results we are looking for -

We are actually checking for multiple tasks,

Suppose we have 3 tasks in the workflow, the below states we want on RITM

1) If all 3 tasks are closed complete then RITM state should be "closed complete"

2) If one of the 3 tasks is closed complete then RITM state should be "closed incomplete"

3) If all tasks are closed skipped then RITM state should be "closed skipped" 

Please let me know where I am doing mistake

[kunal20]

Hi Tejas,

Instead of using if in the second block use else if, use this for reference.

var grTask = GlideRecord('sc_task');

        var completed = 0;

        var skipped = 0;

        var count;

        grTask.addQuery('request_item','7242843e9711111096559300f153af19');

        grTask.query();

        count = grTask.getRowCount();

        while (grTask.next()) {

            if (grTask.getValue('state') === '3') {

                completed++;

            }

            if (grTask.getValue('state') === '7') {

                skipped++;

            }

        }

        if(count == completed){

            gs.log('complete');

        }

        elseif(count == skipped){

            gs.log('skip');

        }

        else

            gs.log('incomplete');

please mark it as helpful

[Ian Mildon]

Not sure on the rest of your Workflow but we have all the states defined at the Catalog Task activity. And depending on the State value set at the SCTASK, the Workflow then updates the RITM.

[Community Alums]

Hi Ian,

We are actually checking for multiple tasks,

Suppose we have 3 tasks in the workflow, the below states we want on RITM

1) If all 3 tasks are closed complete then RITM state should be "closed complete"

2) If one of the 3 tasks is closed complete then RITM state should be "closed incomplete"

3) If all tasks are closed skipped then RITM state should be "closed skipped" 

Thanks,

Tejas

[Ankur Bawiskar]

Hi Tejas,

why not have after update BR on sc_task

Condition: State [IS ONE OF] Closed Complete/Closed Skipped/Closed Incomplete

I think you are saying closed incomplete

2) If one of the 3 tasks is closed incomplete then RITM state should be "closed incomplete"

Regards
Ankur

[Ankur Bawiskar]

@Tejas

Something like this

(function executeRule(current, previous /*null when async*/) {

	// Add your code here

	var closeCompleteCount = 0;
	var closeSkippedCount = 0;
	var closedIncompleteCount = 0;


	var ritm = curent.request_item.getRefRecord();

	var gr = new GlideRecord('sc_task');
	gr.addQuery('request_item', current.request_item); 
	gr.query();
	var totalCount = gr.getRowCount();
	while(gr.next()){
		if(gr.state == 3)
			closeCompleteCount++;
		if(gr.state == 7)
			closeSkippedCount++;
		if(gr.state == 4)
			closedIncompleteCount++;
	}

	if(closeCompleteCount == totalCount)
		ritm.state = 3;

	else if(closeSkippedCount == totalCount)
		ritm.state = 7;

	else if(closedIncompleteCount >= 1)
		ritm.state = 4;

	ritm.update();


})(current, previous);

Regards
Ankur