Build a reference qualifier to show users who are not owners

[Community Alums]

Hi All,

Having a requirement that, 

On catalog form we have a fields like 

> Select the dl - (reference to DL table where we have owner, member) 

> Select user to add owner - reference to user table

here in the select user filed want to add a reference qualifer that validate the users data and show only the user who are not as owners of the selected Dl. 

Stucked here on proceeding further to how to keep this validation. Any suggestions. 

Thanks inadvance. 

[Ankur Bawiskar]

@Community Alums 

As per new community feature you can mark multiple responses as correct.

I believe I also answered your question correctly.

If my response helped please mark it correct as well so that it benefits future readers.

[Community Alums]

Hi @Ankur Bawiskar 

We tried to set the reference qualifier by using the script include and calling that in the reference qualifier like as below

Reference qualifier:

javascript: new fetchSMBmember().getDLNonOwners(current.variables.distribution_list_s);

Script include: 

getDLNonOwners: function(dl) {

        gs.log("DL Members start : " + dl);

        var owner1 = [];

        var owner2 = [];

        var owner3 = [];

        var gr = new GlideRecord('u_distribution_lists');

        gr.addQuery('sys_id', dl);

        gr.query();

        if (gr.next()) {

            // member1.push(gr.u_members.toString());

            owner1 = gr.u_dl_owner.toString().split(',');

        }

        gs.log("DL Members members list 1 : " + owner1);

        var gr1 = new GlideRecord('sys_user');

        gr1.addEncodedQuery('company=7b7db97087e4111012f263df8bbb35a0^active=true');

        gr1.query();

        while (gr1.next()) {

            owner2.push(gr1.sys_id.toString());

        }

        var memberList = new ArrayUtil();

        owner3 = memberList.diff(owner2, owner1);

        return 'sys_idIN' + owner3.toString();

    },

This is working as expected, but facing one issue on the retrieving the data. Its taking more time to response. 

Before the form submission the response is taking more time and after submitting the request on the ritm its showing this error. 

Do you have any idea on this how to handle this.