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)

paulmorris · ‎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

ramak · ‎10-20-2016

Thanks mate, any chance the company value also could be updated to the new value when the caller gets updated ?

jennykin · ‎10-23-2016

Hello Paul / Suhas, any chance you guys have been able to populate the new company value in the company field ? Even I seem to be stuck at the same place

paulmorris · ‎10-24-2016

Sorry, can you please explain what you are trying to do in more detail?

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

ramak · ‎10-24-2016

When I select the another user from a different company, like ACME Australia here for ex., the company field doesn't change to ACME Australia. (Allie P is from ACME Australia & I am using my dev instance here)

ramak · ‎10-24-2016

I wrote an On change client script on 'caller_id' field and this seems to work now.

g_form.setValue('company', caller.company);

Is there any potential pitfalls of using this ?