Advanced reference qualifier not working as expected

ramak · ‎10-16-2016

Hello all, there is a requirement that restricts the users based on the company selected on the Incident form. I have created a script include to do this bit :

var getCurrentCompanyUsers = Class.create();
getCurrentCompanyUsers.prototype = {
       initialize: function() {
   var userslist = '';
   var comp = current.company;
   var usr = new GlideRecord('sys_user');
   usr.addQuery('company',comp.sys_id);
   usr.query();
   while(usr.next()) {
   if(userslist.length > 0) {
   userslist += (',' +usr.sys_id);
   }
   else {
   userslist = usr.sys_id;
   }
   }
   return 'sys_idIN' +userslist;
       },
       type: 'getCurrentCompanyUsers'
};

Still, it is showing the list of all the users in the system and not in the selected company. Is there something I am missing in the code ?

(I can use the dependent functionality but using the advanced ref qualifier so that the filter could be modified at any time)

The SN Nerd · ‎10-18-2016

Unfortunately Reference Qualifiers don't show the query in the breadcrumb.

I posted some code up on how to do it via UI Macro and Field decorators a little while ago.

See my comment on the thread below:

Reference Lookup Initial Filter

I will try adapt it for you below:

Use a UI Macro

http://wiki.servicenow.com/index.php?title=UI_Macros#gsc.tab=0

Then, use the ref_contributions attribute to call it on the field.

Dictionary Attributes - ServiceNow Wiki

<?xml version="1.0" encoding="utf-8" ?>   

<j:jelly trim="false" xmlns:j="jelly:core" xmlns:g="glide" xmlns:j2="null" xmlns:g2="null">   

<j:set var="jvar_n" value="my_company_users_${ref}"/>   

<g:reference_decoration id="${jvar_n}" field="${ref}"   

   onclick="filterUserByCompany(); "   

   title="${gs.getMessage('My Companies Users')}" image="images/icons/tasks.gifx"/>   

<script>   

   function filterUserByCompany() {   

   var thefield = 'caller_id'; //Identify the reference field this should be attached to.   

   var thetable = 'incident'; //This gets whatever table you are on.   

   var lookupfield = 'lookup.'+ thetable + '.' + thefield; //Creates the lookup or reference field ID.   

   var thetarget = thetable + '.' + thefield;   

   var url = "&amp;amp;sysparm_query=company=" + g_form.getValue('company');   

   var refurl = reflistOpenUrl(thetarget, thetarget, thefield, 'sys_user', 'null', 'false', '');   

   var refurlquery = refurl + url;   

   popupOpenStandard(refurlquery, 'lookup');   

   }   

</script>   

 </j:jelly>

ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022

View solution in original post

The SN Nerd · ‎10-24-2016

Depends how you got the 'Caller' variable.

The most efficient way is to get the Company via GlideAjax.

ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022

ramak · ‎10-24-2016

I used a getReference() function with a callback.

jennykin · ‎10-24-2016

Can you please tell how to pull the caller variable via GlideAjax ?

thanks,

jan

The SN Nerd · ‎10-24-2016

See http://wiki.servicenow.com/index.php?title=GlideAjax#gsc.tab=0

Open a new thread if you need further help, this one has already been solved.

ServiceNow Nerd
ServiceNow Developer MVP 2020-2022
ServiceNow Community MVP 2019-2022