question How to make a change request Active to false in Developer forum

How to make a change request Active to false

Mounika66 — Wed, 13 May 2020 07:02:26 GMT

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.

Re: How to make a change request Active to false

hvrdhn88 — Wed, 13 May 2020 07:08:06 GMT

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.

Re: How to make a change request Active to false

Mounika66 — Wed, 13 May 2020 07:36:38 GMT

Hi,

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

Re: How to make a change request Active to false

hvrdhn88 — Wed, 13 May 2020 07:50:14 GMT

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

}

Re: How to make a change request Active to false

Pooja Mallikarj — Wed, 13 May 2020 07:50:26 GMT

Hi,

Can you try with background script ?please let me if you need any help with this.

Thanks,

Pooja M

Re: How to make a change request Active to false

Pooja Mallikarj — Wed, 13 May 2020 07:58:34 GMT

If you have single change request and you want to make that as false then you can use below code.

var gr=new GlideRecord('change_request');
gr.addQuery('sys_id','sys id of your change request');
gr.query();
if(gr.next())
{
gr.active='false';
gr.setWorkflow(false);
gr.update();
}

Thanks,

Pooja M

Re: How to make a change request Active to false

hvrdhn88 — Wed, 13 May 2020 07:59:50 GMT

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

Re: How to make a change request Active to false

AlokD6499012040 — Wed, 13 May 2020 08:00:30 GMT

Hi Mounika,

OOB Close Incomplete choice is not available in the change_request please find the snipped below for reference.

Active field is editable for the admin, It seems like your state field is configured and you have some restrictions configured on writing of active field. If there is no restrictions on writing of active field then reconfirm that you have the admin role to change the field manually.

Also, "mark_closed" business rule on 'change_request' table changes the active field to false. Verify that it has the filter condition added closed incomplete to fix this issue permanently.

Kindly mark my answer as Correct and Helpful based on the Impact.

Regards,

Alok