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

ramak · ‎10-18-2016

Removed the advanced ref qualifier & created a new UI macro called 'filterUsersByComp' and changed the attribute of 'called ID' field to ref_contributions=filterUsersByComp.

Now, after selecting 'KI' company on the Incident form all the 8800+ users are available in the user popup window.

The SN Nerd · ‎10-18-2016

Can you confirm that you are clicking the UI macro button, not the reference qualifier?

Can you also copy the URL from the Reference popup?

Cheers

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

ramak · ‎10-18-2016

*************https://123456.service-now.com/sys_user_list.do?sysparm_target=incident.caller_id&sysparm_target_val...

ramak · ‎10-18-2016

Not sure what you mean by click the UI macro button...

ramak · ‎10-18-2016

no new buttons are visible next to the caller ID field, only the reference lookup one which is why I am seeing all the user records. Am I supposed to see another button next to this ?