Validate parent case mrvs before closing child task

[IreneBest]

I have a case (sn_customerservice_case) which has a child task that I don't want to close until a mrvs on the parent is not empty.

I have created a Before Update Business Rule and while this appears to validate correctly if I attempt to close the child task with an empty mrvs, it also does not recognise when the mrvs is not empty and issues an error.

The code is:

(function executeRule(current, previous /*null when async*/) {

    var parentCase = new GlideRecord('sn_customerservice_case'); // Adjust table name if needed

    if (parentCase.get(current.parent)) {

        var mrvsData = parentCase.variables.approved_quantities_backend;

        if (gs.nil(mrvsData) || mrvsData == '[]') {

            gs.addErrorMessage('You cannot close this task. The Approved Quantities on the Parent must be completed.');

            current.setAbortAction(true); // Aborts the save/close action

            return;

        }

    }

})(current, previous);

Any help would be appreciated.

[Tanushree Maiti]

Hi @IreneBest 

Your are using setAbortAction(). Then why you have added "return;"

Remove Return; line

(function executeRule(current, previous /*null when async*/) {
    var parentCase = new GlideRecord('sn_customerservice_case');
    if (parentCase.get(current.parent)) {
       var mrvsData = parentCase.variables.approved_quantities_backend; 
        if (gs.nil(mrvsData) || mrvsData == '[]' || mrvsData == '') {
             gs.addErrorMessage('You cannot close this task. The Approved Quantities on the Parent must be completed.');
            current.setAbortAction(true);
        }
    }

})(current, previous);

[IreneBest]

Thanks for the quick reply.

Unfortunately this did not fix the issue, only made it appear that the task was closed when it wasn't.

[Tanushree Maiti]

Hi @IreneBest 

Try this script with Before Update BR 

condition: State changes to Closed 

Sample script:

(function executeRule(current, previous /*null when async*/) {

    var parentCase = new GlideRecord('sn_customerservice_case');

    if (parentCase.get(current.parent)) {         

             var mrvsJson = parentCase.variables.approved_quantities_backend;

            var isEmpty = true;

        if (mrvsJson) {

            var parsedData = JSON.parse(mrvsJson);

            if (parsedData.length > 0) {

                isEmpty = false;

            }

        }

        if (isEmpty) {

            gs.addErrorMessage(‘You cannot close this task. The Approved Quantities on the Parent must be completed.');

            current.setAbortAction(true);

        }

[IreneBest]

Hi @Tanushree Maiti 

This code has not worked either.

Thanks