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

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

Arjun Reddy Yer · ‎03-09-2023

but Change Request is already getting created from below mentioned workflow

is there any another way

Ankur Bawiskar · ‎03-09-2023

@Arjun Reddy Yer

are you storing RITM details on CHG form using some field?
if yes then you can have after update BR on sc_task and query CHG with the RITM and update the state.

what script did you start with?

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

Arjun Reddy Yer · ‎03-09-2023

Just RITM Number is storing on Change Form.

As need to auto populate the status of Change Request form depend upon the status of Catalog Task form