Again this is the advanced reference qualifier. Scripts are executed in order from low to high. only the ones they're not in. Are you ready to start your journey with ServiceNow? We have the catalog item (reference video at 2:40) that we're going to use as an example. There's no dynamic filters on this table, so if we want to use that user groups dynamic filter that we created earlier, we're going to need to go to the sys_user_group table. One of these configurations is the. ", http://wiki.servicenow.com/index.php?title=Reference_Qualifiers, "Active User" Reference Qualifier Examples, Table: Incident [incident]Column: caller_idReference Qualifier: active=true, Table: Task [task]Column: assigned_toReference Qualifier: active=true^roles=itil, Table: Change Request [change_request]Column: requested_byReference Qualifier: active=true, Table: Request [sc_request]Column: requested_forReference Qualifier: active=true, Table: VariablesColumn: Any Variable that is a Reference of the User TableReference Qualifier: active=true, 2022 by ServiceNow Elite. Thanks for the contribution! Copyright 2022 GlideFast Consulting LLC - All rights reserved. We specifically look at how we can call a server side script include in the qualifier itself to do some GlideRecord query magic and return a list of sys ids. The CMDB CI Class Models app provides customers and ISV partners with out-of-the-box classes for the Discovery and Service Mapping Patterns app. In the first field, we can select a user, and what it will do is return all the groups that they're not in, so that you can add them to those groups. Is it possible that i can dynimically change reference table on a field based on value in the another field? In the add to the group field, it will bring back all the groups they are not a part of. Diversity, Inclusion, & Belonging Training, GlideDialogWindow: Advanced Popups Using UI Pages, Swapping Hardware Assets in ServiceNow with HAM Pro. A reference qualifier is a tool that helps you filter out data that's returned by reference field, list collector, or anything that goes and grabs info from another table and brings it back to your reference field. This works great on Helsinki and also allows for CIs to be included in as many groups as you want. Setting Up a Simple Reference Qualifier Use the code below: var filter = g_list.get ('variable_name'); filter.setQuery ('active=true') If there is a reference qualifier set . You can imagine if you had to do this constantly for 100 different CIs how much of a pain that could become :). These types of questions are probably better suited to the ServiceNow community site. All Rights Reserved. The reference qualifier may either be a static encoded query string or JavaScript code that returns an encoded query string. To view them, navigate to the System Definition > Dictionary, and then filter on records where Reference qual is not empty. Open image in new tab to clearly view its content. Can my creature spell be countered if I cast a split second spell after it? This is probably up for debate, but I decided to keep the same object format for Ive cleaned up your script quite a bit, but Im not sure if its going to completely fix your issue because I dont have access to the instance youre working on. If you have further questions please ask on the ServiceNow community site. dynamic qualifier to designing and a user? A reference qualifier is a tool that helps you filter out data that's returned by reference field, list collector, or anything that goes and grabs info from another table and brings it back to your reference field. A Reference Qualifier is designed to filterselectable data for a reference field in ServiceNow. This script should eliminate the errors youre seeing (and solve several other issues I noticed). These are not setup OOB due to varying customer needs. Again, the main difference between an advanced reference qualifier and a dynamic one is that after you set up a dynamic reference qualifier on the dynamic filters options table, you can reuse that anytime you select dynamic reference qualifier, as long as your function and your script include take into account whatever item you're going to use it on, or whatever variables it needs. Servicenow does not offer the option to make one field dependent on another within a Wizard like you would with a normal dictionary entry but we can offer the same functionality using an advanced reference qualifier. I came across this through looking for something else in connection with CMDB. I really liked this functionality but when I loaded it in my other Configuration Group items lost the tabs for Changes, Incidents and Problems that were linked to them Is there anyway to not lose that information but still use this update set? Reference qualifiers are used to filter records of the target table that gets referenced on. You're going to have a type of reference field selected and in your type specifications, you're going to select your table that you're referencing. The function of interest is the .getSpots() function. Any idea why this is happening? The same script is shown for simplicity sake. getCIList ( current. Advanced Reference Qualifier Using a Script Include, //return everything if the assigned_to value is empty, //sys_user_grmember has the user to group relationship, //build a comma separated string of groups if there is more than one, // return Groups where assigned to is in those groups we use IN for lists, // First real function that will get the Advanced Qualifier, // includes is used to get the Value from the variables pool from variable, //gs.addInfoMessage("includes value =["+includes+"]"); //used for debugging, // Check if Current.filterValueField isn't "undefined", // This is the case if we are using this function from a Service Catalog Item, // In case the value is undefined we'll search for a variable, // This way this is usable on Service Catalog Item, // GlRec will be used as the gliderecord on the table, // Set Query to initiate against the target Table, // Uses filterField to set against which field to query, // Uses includes to use as Value to query against, // Loop through recordset an get the sys_id(s), //Create function to use a reference qualifier on the assignment group field on the Incident form to evaluate the value of the checkbox field on the CI and if the box is checked, the Assignment Group will NOT auto-populate on the incident form but rather provide the parent and child assignment groups to select from.