Override reference qualifier to call script include is not giving proper result

[learn nv]

Hi All,

I am trying to display the assignment group values based on Assignedto field value in change request. If Assigned to is empty i need to show all the available groups of type itil.

The issue is, I used log statements in script include and observed that script include is getting called and resulting in limited groups as expected. But, on to the change form, when i clicked on the assignment group all the groups are getting shown and no filtering is happening. Do I need to change anything while retuning the records from script include?

Script include:

function populateAssignmentGroup(user) {

    var groups = '';

    var finalgroups = [];  

    if (user != '') {

        var grmember = new GlideRecord('sys_user_grmember');

        grmember.addEncodedQuery('user=' + user + '^group.typeLIKE1cb8ab9bff500200158bffffffffff62^group.active=true');

        grmember.query();

        while (grmember.next()) {            

            groups = groups + grmember.group.sys_id + ',';

        }

        groups = groups.slice(0, -1);

        var grGroups = new GlideRecord('sys_user_group');        

        grGroups.addEncodedQuery('sys_idIN'+groups);

        gs.addInfoMessage('sysid: ' + groups);

        grGroups.query();

        while (grGroups.next()) {

            finalgroups.push(grGroups.sys_id);          

        }

        return finalgroups;

    } else {

        var grGroupselse = new GlideRecord('sys_user_group');

        grGroupselse.addActiveQuery();

        grGroupselse.addEncodedQuery('typeLIKE1cb8ab9bff500200158bffffffffff62');

        grGroupselse.query();

        while (grGroupselse.next()) {

            finalgroups.push(grGroupselse.sys_id);

        }      

        return finalgroups;

    }

}

Dictionary override:

[Rafael Batistot]

Hi @learn nv 

This support link might help you 

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0831564

[M Iftikhar]

Hi @learn nv ,

I think you need to make your Script Include is client-callable and returns an encoded query string.
Please refer to the following documentations:

Reference Qualifier: Reference qualifiers

Encoded Query String: Encoded query strings

Hope it will help you.

Thanks & Regards,
Muhammad Iftikhar
If my response helped, please mark it as the accepted solution so others can benefit as well.

[Ankur Bawiskar]

@learn nv 

you should return encoded query from your function

function populateAssignmentGroup(user) {

    var groups = '';

    var finalgroups = [];

    if (user != '') {

        var grmember = new GlideRecord('sys_user_grmember');

        grmember.addEncodedQuery('user=' + user + '^group.typeLIKE1cb8ab9bff500200158bffffffffff62^group.active=true');

        grmember.query();

        while (grmember.next()) {

            groups = groups + grmember.group.sys_id + ',';

        }

        groups = groups.slice(0, -1);

        var grGroups = new GlideRecord('sys_user_group');

        grGroups.addEncodedQuery('sys_idIN' + groups);

        gs.addInfoMessage('sysid: ' + groups);

        grGroups.query();

        while (grGroups.next()) {

            finalgroups.push(grGroups.sys_id);

        }

        return finalgroups;

    } else {

        var grGroupselse = new GlideRecord('sys_user_group');

        grGroupselse.addActiveQuery();

        grGroupselse.addEncodedQuery('typeLIKE1cb8ab9bff500200158bffffffffff62');

        grGroupselse.query();

        while (grGroupselse.next()) {

            finalgroups.push(grGroupselse.sys_id);

        }

        return 'sys_idIN' + finalgroups.toString();

    }

}

If my response helped please mark it correct and close the thread so that it benefits future readers.

[anurampalli]

I checked this and it works with the following reference qualifier override on assignment_group on incident table:

javascript:new AssignmentGroupUtils().getAssignmentGroupQuery(current ? current.assigned_to : '');