Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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

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