story should not close if associated defect is open

[Prakash_S]

I have a requirement to prevent story closer if defect is still active.

I tried with writing BR but not working.

(function executeRule(current, previous /*null when async*/) {
    // Query the defect table for associated defects
    var defectGr = new GlideRecord('rm_defect'); // Replace 'rm_defect' with the actual defect table name
    defectGr.addQuery('story', current.sys_id); // Assuming 'story' is the reference field on the defect table
    defectGr.addQuery('state', '!=', 'Closed'); // Replace 'state' and 'Closed' with actual field and value
    defectGr.query();

    if (defectGr.hasNext()) {
        // Prevent the story from being closed
        gs.addErrorMessage('This story cannot be closed because it has associated defects that are still open.');
        current.state = previous.state; // Revert the state change
        gs.log('Story closure prevented due to open defects: ' + current.number, 'Story Closure Rule');
    }
})(current, previous);

[Runjay Patel · Accepted solution]

Hi @Prakash_S ,

You can achieve it via configuration of BR.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------

[ag0908]

Hello Prakash,

You have not specified which table this BR is running on, assuming it is on Story table.

Use below instead of trying to revert state to previous state.

Your BR should also run on before so state change can be prevented.

Additional improvement, use GlideAggregate instead of GlideRecord for performance reasons.

current.setAbortAction(true);

Br, Abhishek

[PrashantLearnIT]

Hi @Prakash_S 

 if (current.state.changesTo('closed')) {

        // Query the defect table for associated open defects

        var defectGR = new GlideRecord('rm_defect'); // Replace with the correct table name for defects

        defectGR.addQuery('story', current.sys_id);

        defectGR.addQuery('state', '!=', 'closed'); // Adjust state field and value as needed

        defectGR.query();

        if (defectGR.hasNext()) {

            gs.addErrorMessage('Cannot close the story. It has associated open defects.');

            current.setAbortAction(true); // Prevent the save or update

        }

    }

[ag0908]

Why if condition in code "if (current.state.changesTo('closed'))" ?

This should be in the filter condition field for BR to execute or in Condition field, not in script body.

[Runjay Patel · Accepted solution]

Hi @Prakash_S ,

You can achieve it via configuration of BR.

-------------------------------------------------------------------------

If you found my response helpful, please consider selecting "Accept as Solution" and marking it as "Helpful." This not only supports me but also benefits the community.

Regards
Runjay Patel - ServiceNow Solution Architect
YouTube: https://www.youtube.com/@RunjayP
LinkedIn: https://www.linkedin.com/in/runjay

-------------------------------------------------------------------------