Skip to page contentSkip to chat
ServiceNow support
    • Community
      Ask questions, give advice, and connect with fellow ServiceNow professionals.
      Developer
      Build, test, and deploy applications
      Documentation
      Find detailed information about ServiceNow products, apps, features, and releases.
      Impact
      Accelerate ROI and amplify your expertise.
      Learning
      Build skills with instructor-led and online training.
      Partner
      Grow your business with promotions, news, and marketing tools
      ServiceNow
      Learn about ServiceNow products & solutions.
      Store
      Download certified apps and integrations that complement ServiceNow.
      Support
      Manage your instances, access self-help, and get technical support.
Users are unable to find a record when searching in a reference field - Support and Troubleshooting
  • >
  • Knowledge Base
  • >
  • Support and Troubleshooting (Knowledge Base)
  • >
  • Users are unable to find a record when searching in a reference field
KB0691467

Users are unable to find a record when searching in a reference field


2671 Views Last updated : Apr 7, 2024 public Copy Permalink
KB Summary by Now Assist

Issue

Symptoms


Here are some scenarios in which a customer might be impacted:

  1. The auto-complete functionality on a reference field is not populating with your expected record
  2. Clicking the magnifying glass icon next to a reference field, then searching through the table in the popup window, does not return the records you are expecting to see
  3. Clicking the magnifying glass icon next to a reference field opens the tree picker, but there are very limited items, and the options you expect to see do not appear.

Release


All

  

Cause


A reference qualifier is added to your reference field dictionary record, which filters the data that is returning based on specified conditions.

 

Resolution


If users are not able to return specific records with auto-complete or through the search icon on a reference field, they will want to check the following:

  1. Is there a reference qualifier set up for your field? Right click on your field name, click the option to "Show - 'field_name'", and check the "Reference Qual" section on the Dictionary Info popup window.

  2. If there is a reference qualifier present, please verify that the records you expect to see meet all the conditions.
    For example, if the reference qualifier says - install_status!=7^sys_class_name=cmdb_ci_computer^ORsys_class_name=cmdb_ci_desktop_pc^ORsys_class_name=cmdb_ci_laptop_pc
    In order for your record to be found in your reference field, it cannot have an install_status of 7 AND it must have a sys_class_name of cmdb_ci_computer OR cmdb_ci_desktop_pc OR cmdb_ci_laptop_pc. If the record does not meet these two requirements, the record will not be found. It will still be accessible if you navigate directly to the table that houses the record, but it will not return in the reference field.

  3. Verify that there is not a Dictionary Override record that specifies different conditions for your reference field.
    On extended tables, admins can create a Dictionary Override record on a child table field, if they want the field to have different requirements than what is seen on the dictionary record of the parent table. Many times, customers will forget to check the Dictionary Override table when they encounter this issue. The easiest way to access your dictionary override records is to right click in the header of your form > Configure > All. The resulting page will show you all Configurations for your current table. Navigate to the Dictionary Entry Overrides tab and search for your reference field. Check if there is an override record available for your field, and verify if the reference qualifier is different. 

The world works with ServiceNow.

Sign in for more! There's more content available only to authenticated users Sign in for more!
Did this KB article help you?
Did this KB article help you?

How would you rate your Now Support digital experience?

*

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

Very unsatisfied

Unsatisfied

Neutral

Satisfied

Very satisfied

What can we improve? Please select all that apply.

What are we doing well? Please select all that apply.

Tell us more

*

Do you expect a response from this feedback?

  • Terms and conditions
  • Privacy statement
  • GDPR
  • Cookie policy
  • © 2025 ServiceNow. All rights reserved.