Advanced Reference Qualifier with Script Include not working

[Vinicius Luz]

Hello,

I have a reference field pointing to the sys_user table called "GP Approvers" attached to a MRVS on the portal

I need it to filter its choices based on a group, to show only this group members. Here's my code

Script Include:

getGPapprovers: function() {

        var users = [];
        var gr = new GlideRecord("sys_user_grmember");
        gr.addQuery("group", "2d5b43881b864110d9ad0dcbe54bcb5c");
        gr.query();
        while (gr.next()) {
            users.push(gr.getValue("user"));
        }

        return 'sys_idIN' + users.join();
    },

Field:

In my understanding this is properly set, unless I'm not seeing the error. Or even the MRVS doesnt accept this setup ...

Whats wrong ?

[Shakeel Shaik]

Hi @Vinicius Luz 

I want to know, How you are passing the group sys_id.

is group sys_id is static or dynamic??

Please check and let us know.

Thanks 🙂

[Hitoshi Ozawa]

Try converting the user to String when pushing.

users.push(gr.getValue("user").toString());

[Shakeel Shaik]

Hi @Vinicius Luz 

Here I updated the script.

getGPapprovers: function() {

        var users = [];
        var gr = new GlideRecord("sys_user_grmember");
        gr.addQuery("group", "2d5b43881b864110d9ad0dcbe54bcb5c");
        gr.query();
        while (gr.next()) {
            users.push(gr.getValue("user"));
        }

       var vQuery  = 'sys_idIN' + users;

       return JSON.stringify(vQuery);
    },

 

Please check and let us know.

Thanks 🙂

[Shakeel Shaik]

Hi @Vinicius Luz 

Use this script in Your Reference Qualifier.

sys_idINjavascript: new CriacaoUtils().getGPapprovers();^EQ

Please check and let me know.

Thanks 🙂