Dictionary Override defined on task table's Assignment Group for a custom table is not working

[kartikchoum]

We have a custom table that uses assignment group field from the task table(parent table). However I can see all of a sudden the dictionary override is no longer working. For our custom table the support group selectable should be limited to certain process groups but currently we are able to select all the assignment groups listed in sys_user_group.

Does anyone have any idea why this is happening?

[Ankur Bawiskar]

@kartikchoum 

you can create dictionary override and add your reference qualifier and restrict the records

share screenshot for what you configured

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[kartikchoum]

Hi Ankur,

We already have one configured, it just happens to work for many but not for some. Even though the roles are same.

[Ankur Bawiskar]

@kartikchoum 

you didn't share the config screenshots

[kartikchoum]

I can't share most of it, but here's how it looks like:

Base table: Task [task]

Table: ABC Case [x_abc_case]

Column name: assignment_group
Override reference qualifier: true

Reference qualifier:  javascript:'sys_idIN'+new  AbcGroupList().caseGrpList(current);


The script:

caseGrpList: function(grCase) {

        var myProcess = grCase.u_my_process.getDisplayValue();

        var query = '';

        if (grCase.reassign_case == true) {

            query = 'active=true^typeLIKEsysId1^ORtypeLIKESysId2^ORtypeLIKESysId3';

        } else {

            if (businessprocess == 'ABC1')

                query = 'typeLIKESysId1^active=true';

            else if (businessprocess == 'ABC2')

                query = 'typeLIKESysId2^active=true';

            else if (businessprocess == 'ABC3')

                query = 'typeLIKESysId3^active=true';

        }

        var sysid = '';

        var theGrpList = new GlideRecord('sys_user_group');

        theGrpList.addEncodedQuery(query);

        theGrpList.query();

        while (theGrpList.next()) {

            sysid +=theGrpList.sys_id + ",";

        }

        return sysid;

    }