How to call script include into the reference qualifier

Ram050670
Tera Guru

Script include

getGroupDetails: function getIDs() {
        var grp = gs.getProperty('VP_Group');
        var mem = GlideUserGroup.getMembers(grp);
        var ids = '';
        while (mem.next()) {
            ids += (mem.user + ',');
        }
        return ids;
    },
 
 
Table is sys_user
reference Qualifier: javascript: new catalogClientUtil().getGroupDetails(grp);
can someone help with correct if this is correct
1 ACCEPTED SOLUTION

@anshul_goyal @RAMANA MURTHY G 

Update on this found the solution.

 

Script Include:

getMember: function() {
        var grp = gs.getProperty("Test_My_Group");
        var user_array = [];
        var getMembers = new GlideRecord('sys_user_grmember');
        getMembers.addQuery('group', grp);
        getMembers.query();
        while (getMembers.next()) {
             user_array.push(getMembers.user + '');
        }
        return 'sys_idIN' + user_array.toString();
    },
 
Reference Qualifier: javascript:new CatalogClientUtil().getMember();
 

View solution in original post

5 REPLIES 5

anshul_goyal
Kilo Sage

Hello @Ram050670,
I guess you made some mistakes in the reference qualifier as well as the script include.
Are you trying to pass any argument through a reference qualifier and get it in the script include? If not then,

Reference Qualifier: javascript: new catalogClientUtil().getGroupDetails();
Script Include: 
 

getGroupDetails: function() {
        var grp = gs.getProperty('VP_Group');
        var mem = GlideUserGroup.getMembers(grp);
        var ids = '';
        while (mem.next()) {
            ids += (mem.user + ',');
        }
        return ids;
    },


I hope this will help you solve your problem. Please mark it as Accepted and Helpful.
Thanks and Regards,
Anshul

Hi @anshul_goyal,

i am trying to get the value from script include, so that it will show the users list in lookup select box.

tried your script but its not working.

Naneen_0-1695735926532.png

 

@anshul_goyal @RAMANA MURTHY G 

Update on this found the solution.

 

Script Include:

getMember: function() {
        var grp = gs.getProperty("Test_My_Group");
        var user_array = [];
        var getMembers = new GlideRecord('sys_user_grmember');
        getMembers.addQuery('group', grp);
        getMembers.query();
        while (getMembers.next()) {
             user_array.push(getMembers.user + '');
        }
        return 'sys_idIN' + user_array.toString();
    },
 
Reference Qualifier: javascript:new CatalogClientUtil().getMember();
 

RAMANA MURTHY G
Mega Sage
Mega Sage

Hello @Ram050670 ,

you should write return statement as

return "sys_idIN"+ids;

because the script include returns value to the reference qualifier, so that it should be a filter condition

 

Please mark my answer correct & helpful, if it helps you

Thank you

 

 

Please mark my answer helpful  & correct if it helps you
Thank you

G Ramana Murthy
ServiceNow Developer