Help with change request

[Abhijit Das7]

Hi Everyone,

I am working on change request; the state of change request should not change to "Closed" if any of its change task are in open condition.

Basically, I should be able to close change request if all the change tasks attached to it are in closed state.

please provide some suggestions.

Thanks in advance.

[Harish KM · Accepted solution]

Hi @Abhijit Das7 Create a before update BR on change_request table

Condition: state changesTO complete

script:

    var chgTask = new GlideRecord('change_task');

    chgTask.addQuery('change_request', current.sys_id);

    chgTask.addEncodedQuery('stateIN-5,1,2'); //OPEN,PENDING,WIP

    chgTask.query();

    while (chgTask.next()) {

        gs.addErrorMessage("Change Task are active" + chgTask.getValue('number'));

        current.setAbortAction(true);

    }