custom dynamic filter to show only user's groups

[Alon Grod]

Im trying to create a cusom dynamic filter to show only the incidents that Assignment group is one of user's groups (without parent group).
For some reason it only shows me one group among the groups that i belong to.

 

 

 

I can only see the incidents of one of my groups instead of the two of them:

 

[Peter Bodelier · Accepted solution]

Hi @Alon Grod,

Then it probably is OOTB in some plugin installed in my instance.

This is the underlying code, which you can use:

/**
    	Default filter "One of My Groups - d6435e965f510100a9ad2572f2b47744" includes parent groups too
    	As per defect "DEF0173629" we want only groups the user is part of not parent groups
    */

    getGroupsIAmMemberOfExcludeParents: function(userId) {
        var groups = [];
        var gr = new GlideRecord('sys_user_grmember');
        gr.addQuery('user', userId);
        gr.addQuery('group.active', true);
        gr.query();
        while (gr.next()) {
            var groupId = gr.getValue('group');
            if (!gs.nil((groupId)))
                groups.push(groupId);
        }
        return groups;
    },

[Alon Grod]

@Peter Bodelier hi, i dont have this dynamic OOTB filter. I only have 'One of my groups' which also return the 'Parent' group of the current group and its not helpful. I only need to user's groups without the parent

[Peter Bodelier · Accepted solution]

Hi @Alon Grod,

Then it probably is OOTB in some plugin installed in my instance.

This is the underlying code, which you can use:

/**
    	Default filter "One of My Groups - d6435e965f510100a9ad2572f2b47744" includes parent groups too
    	As per defect "DEF0173629" we want only groups the user is part of not parent groups
    */

    getGroupsIAmMemberOfExcludeParents: function(userId) {
        var groups = [];
        var gr = new GlideRecord('sys_user_grmember');
        gr.addQuery('user', userId);
        gr.addQuery('group.active', true);
        gr.query();
        while (gr.next()) {
            var groupId = gr.getValue('group');
            if (!gs.nil((groupId)))
                groups.push(groupId);
        }
        return groups;
    },

[Alon Grod]

@Peter Bodelier hi but what is the difference between what you sent to what i did?

[Peter Bodelier]

There is very little difference indeed. But what I sent you is created by ServiceNow, and I verified that it is working as per your requirement as well.

[Alon Grod]

@Peter Bodelier  so what should be different here according to your adjustment?