how to auto change status of change request form depends on catalog task status in servicenow

Arjun Reddy Yer · ‎03-09-2023

Can anyone help me in getting this as need to auto change status of Change Request form depends on Catalog Task status in servicenow

as off now when RITM is created then Catalog Task and Change Request are getting created via workflow.

@Ankur Bawiskar @Anil Lande @Sumalatha Y @BharathChintala @mattystern @priyasunku @asifnoor @Pradeep Sharma @SatyakiBose

Sumalatha Y · ‎03-09-2023

Hi,

Configure flow as below to update change status.

Thanks & Mark Answer Correct/Hit Thumbs Up. If my inputs help you to achieve what you are looking.

Sumalatha Y

View solution in original post

Ankur Bawiskar · ‎03-13-2023

@Arjun Reddy Yer

you need to decide which state value to set here -2 or -1

try this updated script

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

var gr = new GlideRecord("change_request");
gr.addQuery("parent", current.request_item);
gr.query();
if (gr.next()) {

if(current.state == '2')
{
gr.state = '-2 || -1'; //choice Value For Scheduled or Implement
gs.info('sample enter 1');
}
else if (current.state == '3')
{
gr.state = '3'; //Choice Value for Closed
gs.info('sample 2');
}else if(current.state == '4')
{
gr.state = '4'; //Choice value for Cancelled
gs.info('sample 3');
}else if(current.state == '1')
{
gr.state = '-5'; //Choice value for open
gs.info('sample 4');
}
gr.update();
}
})(current, previous);

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Arjun Reddy Yer · ‎03-09-2023

can I know how to set proper state value mapping between chg and sc_task

Ankur Bawiskar · ‎03-09-2023

@Arjun Reddy Yer

that you need to discuss with your customer what they want to map

I hope I have answered your question.

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

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Arjun Reddy Yer · ‎03-09-2023

state field only so that when ever catalog task state changes then change request state will be getting changed

Ankur Bawiskar · ‎03-09-2023

@Arjun Reddy Yer

please discuss this with your customer.

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

Arjun Reddy Yer · ‎03-09-2023

after discussion with customer only as the highlighted stages needs to get auto populate when the Catalog Task State changes

Catalog Task Change Request

Open = Open

Work in Progress = Scheduled, Implement

Closed Complete = Closed

Closed Incomplete = Canceled