Advanced Reference Qualifier

[divvi_vamsi]

I am trying to use the script include from Wiki;

Reference Qualifiers - ServiceNow Wiki   --> javascript:new BackfillAssignmentGroup().BackfillAssignmentGroup()

I tried logging the values of the comma separated string, which is accurate, but the filter on the form doesn't work as expected. Not sure what is missing in there.

var BackfillAssignmentGroup = Class.create();

BackfillAssignmentGroup.prototype = {

initialize: function() {

},

BackfillAssignmentGroup:function() {

var gp = ' ';

var a = current.u_group; //custom field in current form

//return everything if the assigned_to value is empty

if(!a)

return;

//sys_user_grmember has the user to group relationship

var grp = new GlideRecord('u_members'); //my custom table

grp.addQuery('u_code',a); //custom field in u_members

grp.query();

while(grp.next()) {

if (gp.length > 0) {

//build a comma separated string of groups if there is more than one

gp += (',' + grp.u_mem); //custom field in current form

}

else {

gp = grp.u_mem;

}

}

gs.log(gp);

// return Groups where assigned to is in those groups we use IN for lists

return 'sys_idIN' + gp;

},

type: 'BackfillAssignmentGroup'

};

Reference Qual: javascript:new BackfillAssignmentGroup().BackfillAssignmentGroup()

can someone please help with what is missing in here!!!

Thanks

Divya

[PriyaRanji]

Hi Divya,

Good Day

Can you try to add the gs.log() in the script provided by Harsh/Shishir and try to find till where you get the log as expected.

Thanks,

Priyanka R

[Harsh Vardhan]

if you are doing it on PDI then i can have look into this.

by the way can you please share the screenshot of your custom table form.

put some log in your script and validate what's coming in your log.