question Re: Set RITM to Pending if any linked SCTask is set to Pending in Developer forum

Set RITM to Pending if any linked SCTask is set to Pending

steveturley — Mon, 20 Feb 2023 16:37:33 GMT

I need for the linked RITM to be set to 'Pending' when any of the associated SCTasks are set to 'Pending'

When none of the associated SCTasks are pending, the RITM needs to move back to 'Work in Progress'

Can anyone help please?

Thanks!

Re: Set RITM to Pending if any linked SCTask is set to Pending

BharathChintala — Mon, 20 Feb 2023 16:58:48 GMT

@steveturley

Scenaro -1 :

you can write After business rule on SCTask table

conditions

SCTask state changes to pending and

request_item. state is not pending

on insert and update

in advanced script

var gr = new GlideRecord('sc_req_item');

gr.get(current.request_item);

gr.state = 'pending';// replace back end value mostly it will be numeric value

gr.update();

Scenario 2:

After BR on SCTask table

Conditions

State changes from pending

and request_item.state is not WIP

On insert and update

in advance Script

var task = new GlideRecord('sc_task');

task.addQuery('request_item',current.request_item);

task.addQuery('state','!=','pending');// replace back end value mostly it will be numeric value

task.query();

if(task.next()){

//do nothing

}else{

var gr = new GlideRecord('sc_req_item');

gr.get(current.request_item);

gr.state = 'WIP';// replace back end value mostly it will be numeric value

gr.update();

}

Re: Set RITM to Pending if any linked SCTask is set to Pending

steveturley — Tue, 21 Feb 2023 10:38:54 GMT

Hi, thanks for the reply

Scenario 1 works perfectly - thanks!

Scenario 2 doesn't work at the moment. I change the sc_task state from 'pending' but the RITM state doesn't change.

I amended the values for 'pending' & 'WIP'. Screenshot attached

Re: Set RITM to Pending if any linked SCTask is set to Pending

BharathChintala — Tue, 21 Feb 2023 12:03:45 GMT

@steveturley

After BR on SCTask table

Conditions

State changes from pending

and request_item.state is not WIP

On insert and update

in advance Script

var task = new GlideRecord('sc_task');

task.addQuery('request_item',current.request_item);

task.addQuery('state','-5');// replace back end value mostly it will be numeric value

task.query();

if(task.next()){

//do nothing

}else{

var gr = new GlideRecord('sc_req_item');

gr.get(current.request_item);

gr.state = 'WIP';// replace back end value mostly it will be numeric value

gr.update();

}

My bad that should be not != just pending try above code

Re: Set RITM to Pending if any linked SCTask is set to Pending

steveturley — Tue, 21 Feb 2023 14:14:51 GMT

Hi @BharathChintala

I replaced the code but it doesn't work unfortunately. The RITM remains in state 'pending'.

Thanks

Steve

Re: Set RITM to Pending if any linked SCTask is set to Pending

steveturley — Tue, 21 Feb 2023 14:48:11 GMT

Hi @BharathChintala

Apologies!

I replaced your code but didn't change the 'WIP' value. I have done so now and it works.

Many thanks! Really appreciate your help.

Steve

Re: Set RITM to Pending if any linked SCTask is set to Pending

Lavanya Marella — Thu, 15 Feb 2024 05:00:45 GMT

Hi,

Can you please paste both the scripts here.

Thanks in advance.