Client Script

[ARAVIND22]

@Ankur Bawiskar/friends,  Sir please help

I need to Update the State in RITM which is showing as  what ever the value is showing below I have to make it to closed complete - state. When the stage is complete

1- work in progress

2 - pending

3 - Open

PLEASE HELP VERIFY IMAGE ATTACHED AS WELL

[praneeth7 · Accepted solution]

Hi Aravind,

This script will do the work. Just try to run it in Background-script

var item = new GlideRecord('sc_req_item');
item.addActiveQuery();
item.query();
while(item.next()){
       var label = item.getDisplayValue('stage');
       if(label == 'Completed'){
       var value = item.getValue('state');
       if(value == 1 || value== 2 || value == -5){
       item.setValue('state',3);
       gs.print(value);
       item.update();
}
}
}

Please mark my answer as helpful or solution if this helps you,

Thank you.

[Ankur Bawiskar]

@ARAVIND22 

so what script did you start with?

[ARAVIND22]

@Ankur Bawiskar  Can you help this with encoded query instead of while loop

var item = new GlideRecord('sc_req_item');
item.addActiveQuery();
item.query();
while(item.next()){
       var label = item.getDisplayValue('stage');
       if(label == 'Completed'){
       var value = item.getValue('state');
       if(value == 1 || value== 2 || value == -5){
       item.setValue('state',3);
       gs.print(value);
       item.update();
}
}
}

[Ankur Bawiskar]

@ARAVIND22 

you can form it on table list using filter conditions

var encodedQuery = 'stage=complete^stateIN-5,1,2';

You can also use updateMultiple() for fast update

var item = new GlideRecord('sc_req_item');
item.addEncodedQuery('stage=complete^stateIN-5,1,2');
item.addActiveQuery();
item.query();
item.setValue('state',3);
item.updateMultiple();

If my response helped please mark it correct and close the thread so that it benefits future readers.

[praneeth7 · Accepted solution]

Hi Aravind,

This script will do the work. Just try to run it in Background-script

var item = new GlideRecord('sc_req_item');
item.addActiveQuery();
item.query();
while(item.next()){
       var label = item.getDisplayValue('stage');
       if(label == 'Completed'){
       var value = item.getValue('state');
       if(value == 1 || value== 2 || value == -5){
       item.setValue('state',3);
       gs.print(value);
       item.update();
}
}
}

Please mark my answer as helpful or solution if this helps you,

Thank you.