Reference qualifier on the record producer

[Kaustubh k]

Hi All,

Thanks for checking my post.

We have reference qualifier in the incident form on a custom field  service  as :

javascript:new incidentServerUtils().getService(current.caller_id);

which triggers;

var incidentServerUtils = Class.create();

incidentServerUtils.prototype = {

    getService: function(cur) {

var gr = new GlideRecord('sys_user');

gr.addQuery('sys_id',cur);

gr.query();

if(gr.next()){

var assigneeLoc = gr.location.country;

}

return 'u_location='+assigneeLoc+'^ORu_location=';

    },

    type: 'incidentServerUtils'

};

Now when i am trying to use the same in Record producer filed which has variable service, its not taking up the further flow and not triggering the logic in Script include.

looking forward for a feedback on this.

Thanks

Karan

[Mallidi Suma]

Hi @Kaustubh k ,

In your script, you are sending current.caller_id to the server side script as a parameter to script includes. This will work with form reference field Reference Qualifiers.

javascript: new incidentServerUtils().getService(current.caller_id);

But I have observed, this won't work to Reference fields in variables in Catalog Items. So as a workaround Instead of sending the parameter you can use the gs.getUserID() function in your script include.

Please mark my answer as helpful, if it helps you!!

[Kaustubh k]

Hello @Mallidi Suma 

Thanks for reviewing this, could you please help with the SI changes and also the ref qualifier to me modified on the field,which triggers the SI.

var incidentServerUtils = Class.create();

incidentServerUtils.prototype = {

    getService: function(cur) {

var gr = new GlideRecord('sys_user');

gr.addQuery('sys_id',cur);

gr.query();

and refernce qualifier changes on : javascript:new incidentServerUtils().getService(current.caller_id);

[KB18]

Dear @Kaustubh k 

You can use OnDemand Script Include to achieve your requirement.

For reference: Advanced Reference Qualifier Using a Script Include - ServiceNow Guru

[Ankur Bawiskar]

@Kaustubh k 

the reference variable is referring to which table?