How to make a change request Active to false

[Mounika66]

I have a change request whose state was closed incomplete. But still active shows true instead of false.

How can I manually make active false?

Thanks in advance.

[Harsh Vardhan]

if you are an admin you can manually change it from list. 

but proper root cause of this issue can be fixed from your workflow, you need to check which activity set the state value as closed incomplete and there add active is false also. 

[Mounika66]

Hi,

I cannot manually change from the list. Is there any other way I can make it false?

[Harsh Vardhan · Accepted solution]

background script

var gr = new GlideRecord('change_request');

gr.addEncodedQuery('state=4^active=true'); //make sure about closed incomplete state value

gr.query();

while(gr.next()){

gr.active=false;

gr.setWorkflow(false);

gr.update();

}

[Harsh Vardhan]

for single record 

var gr=new GlideRecord('change_request');
gr.get('sys id of your change request');
gr.active=false;
gr.setWorkflow(false);
gr.update();