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

[Arjun Reddy Yer]

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 · Accepted solution]

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]

Tried with the below mentioned script but when the Catalog Task state changes to "Work in Progress" the the Changes Request state is changing to "Scheduled" after that when the Catalog Task State value changes to "Closed Complete" the the Change Request state value is changing to "Canceled".

In logs it's entering into gs.info('sample enter 1') only

it's not entering into remaining logs

(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 enter 2');
}

else if(current.state == '4')
{
gr.state = '4'; //Choice value for Cancelled
gs.info('sample enter 3');
}

else if(current.state == '1')
{
gr.state = '-5'; //Choice value for open
gs.info('sample enter 4');
}
gr.update();

}
})(current, previous);

[priyasunku]

@Arjun Reddy Yer  please use the below code again there is a mistake with } closure.

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);

Please dont make any changes just copy same.

If my answer solved your issue, please mark my answer as ✅Correct & 👍Helpful

[Arjun Reddy Yer]

Tried with the below mentioned script but when the Catalog Task state changes to "Work in Progress" then the Changes Request state is changing to "Scheduled" after that when the Catalog Task State value changes to "Closed Complete" then the Change Request state value is changing to "Canceled" instead of "Close". With the logs able to view that only sample enter 1 is executing.

@Ankur Bawiskar @Sumalatha Y @priyasunku @Anshu_Anand_ @Anil Lande @Community Alums @Allen Andreas 

Task Table Values of State Field:

Change Request Table Values of State Field:

Business Rule which had written

(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 enter 2');
}

else if(current.state == '4')
{
gr.state = '4'; //Choice value for Cancelled
gs.info('sample enter 3');
}

else if(current.state == '1')
{
gr.state = '-5'; //Choice value for open
gs.info('sample enter 4');
}
gr.update();

}
})(current, previous);

[priyasunku]

@Arjun Reddy Yer  what are you getting in logs.

If my answer solved your issue, please mark my answer as ✅Correct & 👍Helpful

[Arjun Reddy Yer]

In logs it's entering into gs.info('sample enter 1') only

it's not entering into remaining logs