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

 

 

@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

If my inputs have helped with your question, please mark my answer as accepted solution, and give a thumb up.
Bharath Chintala

View solution in original post

Hi @BharathChintala 

 

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

 

Thanks

Steve

 

 

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

Lavanya Marella
Tera Contributor

Hi,

 

Can you please paste both the scripts here.

 

Thanks in advance.