Update Stage on RITM using script

[Community Alums]

Hi Team,

We had an issue with workflow so requests were not closed properly & we have fixed that issue. But want to close the old records.

RITM state is set to Closed Complete on them but Stage is still showing as Fulfillment and REQ is also active.

How can we set Stage (field type - workflow) field to Completed and close out REQ using script?

Thank you.

[Community Alums]

SC_Tasks are already closed.

RITM Screenshot

[Martin Ivanov]

Then I would suggest to go and close all the requests with another background script:

var requestGR = new GlideRecord('sc_request');
requestGR.addActiveQuery();
requestGR.query();
while(requestGR.next()){
requestGR.setValue('request_state','closed_complete')
requestGR.setValue('stage','closed_complete')
requestGR.setValue('state','3')
requestGR.update();
}

Please mark Correct and Helpful if appropriate. Thanks!

[Martin Ivanov]

@mjs9  if this helped you resolve the query, please mark Correct.

[Sourabh26]

Hi,

You need to close all the task first which are associated with that RITM and then close the RITM then REQ. 

Mark this as Helpful/Correct if applicable.

Regards,

Sourabh

[Community Alums]

Hi

SC_Tasks are already closed. Due to workflow issue RITM Stage was impacted and didn't close REQ