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.
A reference qualifier to [sys_user_group] breaks if more than one field references [sys_user_group] - Known Error
  • >
  • Knowledge Base
  • >
  • Known Error (Knowledge Base)
  • >
  • A reference qualifier to [sys_user_group] breaks if more than one field references [sys_user_group]
KB0598666

A reference qualifier to [sys_user_group] breaks if more than one field references [sys_user_group]


8083 Views Last updated : Mar 20, 2025 public Copy Permalink English (Original)
  • English (Original)
  • Japanese
KB Summary by Now Assist

Description

If more than one field on a table references [sys_user_group], the following issues may occur:

  • reference qualifiers to [sys_user_group] might not work as expected
  • dependency relationship between assigned_to and assignment_group fields may not work correctly (user lookup may return an empty list when Assignment Group is selected)

Steps to Reproduce

  1. Open an incident, and set Assignment Group to Hardware.

  2. Click the reference icon (magnifying glass) next to Assigned to.

    A list displays the users belonging to the Hardware group. SQL debug will show a select from the [sys_user_grmember] table with a condition matching the group field with a sys_id from the selected Assignment Group record.

  3. Add a new field on the User table with the following values:

    Table: sys_user
    Type: Reference
    Label: Test PRB705148
    Name u_test_prb705148
    Referenced table: sys_user_group

  4. Open an incident and set Assignment Group to Software.

  5. Click the reference icon next to Assigned to.

    Notice the list shows No records to display. SQL debug will show a select from the sys_user table with a condition matching the group field with a sys_id from the selected Assignment Group record.

Workaround

After carefully considering the severity and frequency of the issue, and the cost and risk of attempting a fix, it has been decided to not address this issue in any current or near future releases.
We do not make these decisions lightly, and we apologize for any inconvenience.

As a workaround, consider one of the two options below:

  1.  In the 'Dependent' config of the 'assigned_to' field, specify the value as 'assignment_group,assignment_group' instead of just 'assignment_group'
  2. Use an "Advanced" Reference Qualifier to specify the selection criteria.
  3. Make sure the name of all fields contain group.
NOTE: You may need to create a new field with the required group in its name (see KB0998861 for more information), transfer the data from the old field, and then remove it. If you need help to implement and avoid data loss, please contact Global Technical Support.

 

 

 


Related Problem: PRB705148

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.