Indicator Task Result - new choice and GRC Issue creation

[Mira1992]

Hello community,

I have a requirement from a customer to create a new choice for the Result field on the Indicator Task table.
I created a new choice on the sys_choice table so now I have these three choices (they also wanted to change the label):

And my Issue is:

When a Result of the Indicator Task is "Non Compliant" (failed), an Issue is created on the related Control. This is OOTB and fine for me.

But when a Result is Not Applicable, Issue is created as well. And I don't want that.
I know there is a BR "Create issue when result fails" but adjusting this BR did not help for me.

Can anyone help me with this?
When an Indicator Task is closed with my new choice, the Indicator Result [sn_grc_indicator_result ] is false so I believe I only need to find out how to set the value of the Indicator Result to true if the Indicator Task result is Not Applicable...

Would any of you know how to achieve this? Or at least hot to stop creating Issues for this Result?
Thanks a lot for any help!

[Satishkumar B]

Hi @Mira1992 

Modify the existing Business Rule that calls the Script Include to override creation of issue. Adjust the BR to add a condition that excludes the “Not Applicable” result to prevent issue creation for this specific result.

please mark it helpful 👍 and accept solution✅ if it helps you!!

[Mira1992]

Hello Satishkumar,
that is exactly what I tried but did not work.

It either creates Issue for both choices, or does NOT create Issues at all.

[Satishkumar B]

@Mira1992 

Use async Business rule on Insert

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

    // Create a GlideRecord object for the sn_grc_indicator_task table

    var indicatorTaskGR = newGlideRecord('sn_grc_indicator_task');

    // Query the record referenced by current.indicator_task

    if (indicatorTaskGR.get(current.indicator_task)) {

        gs.info("MN - Fetched Indicator Task record: " + indicatorTaskGR.sys_id);

        // Log the actual result field value

        var resultValue = indicatorTaskGR.getValue('result');

        gs.info("MN - Indicator Task Result Value: " + resultValue);

        // Check if the result field is populated

        if (resultValue) {            

            // Check if the result is "failed"

            if (resultValue.trim() == "failed") {

                gs.info("MN - Indicator Task Result is 'failed'. Creating or updating issue for record: " + current.sys_id);

                newsn_grc.IssueUtils().updateOrCreateIndicatorIssue(current);

            } else {

                gs.info("MN - Indicator Task Result is not 'failed'. No action taken.");

            }

        } else {

            gs.info("MN - Indicator Task Result is not populated yet.");

        }

    } else {

        gs.info("MN - Could not find Indicator Task record for current.indicator_task: " + current.indicator_task);

    }

})(current, previous);

please mark my response as helpful and accept the solution if it helps

[Mira1992]

I ended up deactivating the OOTB Create issue when result fails BR
And creating a new BR 
table: sn_grc_indicator_result
When: async
on Insert

Script:

(function executeRule(current, previous /*null when async*/) {
// Create a GlideRecord object for the sn_grc_indicator_task table
var indicatorTaskGR = new GlideRecord('sn_grc_indicator_task');

// Query the record referenced by current.indicator_task
if (indicatorTaskGR.get(current.indicator_task)) {
gs.info("Fetched Indicator Task record: " + indicatorTaskGR.sys_id);

// Log the actual result field value
var resultValue = indicatorTaskGR.getValue('result');
gs.info("Indicator Task Result Value: " + resultValue);

// Check if the result field is populated
if (resultValue) {
// Check if the result is "failed"
if (resultValue.trim() == "failed") {
gs.info("Indicator Task Result is 'failed'. Creating or updating issue for record: " + current.sys_id);
new sn_grc.IssueUtils().updateOrCreateIndicatorIssue(current);
} else {
gs.info("Indicator Task Result is not 'failed'. No action taken.");
}
} else {
gs.info("Indicator Task Result is not populated yet.");
}
} else {
gs.info("Could not find Indicator Task record for current.indicator_task: " + current.indicator_task);
}
})(current, previous);


I'm not entirely sure about this solution, but it worked. However, I would still appreciate any suggestions for a better one