Scripted Filter

[dev_K]

Hi,

I am trying to create a report which will show me a list of the ISSUES (sn_grc_issue) where the assignee is not a member of the assignment group (scenario: the assignee changes the group membership and someone else should get assigned to the issue).

I tried the following:

1. Create a script include

2/ Create a report with the condition:

SYS ID /IS ONE OF/ javascript:getInvalidIssues() ;

this does not work. Any suggestions?

Script Include:

function getInvalidIssues() {
    var invalidIssues = [];
    var grIssue = new GlideRecord('incident');
    grIssue.addNotNullQuery('assigned_to');
    grIssue.addNotNullQuery('assignment_group');
    grIssue.query();

    while (grIssue.next()) {
        // Check if the assignee is a member of the assignment group
        var isMember = false;
        var groupMember = new GlideRecord('sys_user_grmember');
        groupMember.addQuery('group', grIssue.assignment_group);
        groupMember.addQuery('user', grIssue.assigned_to);
        groupMember.query();

        if (groupMember.next()) {
            isMember = true;
        }

        // If not a member, include the issue sys_id in the array
        if (!isMember) {
            invalidIssues.push(grIssue.sys_id.toString());
        }
    }

    return invalidIssues;
}

Report filter:

[dev_K]

yes, it is