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 filter of <custom field = empty> is added to charts (bar/pivot) when a custom field has the same name as the table - Known Error
  • >
  • Knowledge Base
  • >
  • Known Error (Knowledge Base)
  • >
  • A filter of <custom field = empty> is added to charts (bar/pivot) when a custom field has the same name as the table
KB0622600

A filter of <custom field = empty> is added to charts (bar/pivot) when a custom field has the same name as the table


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

Description

When a custom field has the same name as a table and display = true, it adds an additional filter <custom field> = empty and hence, does not display results.

 

 

 

Steps to Reproduce

 

  1. Create a table called u_unit
  2. Add a field on u_unit called u_unit, label=Unit Number, type=String, max_length=40, display=true
  3. Navigate to incident and add u_unit as a reference field called Unit Table
  4. On the incident form, add the newly defined reference to u_unit and add some data in the field in an incident
  5. Generate a report on incident table, add a stacked_by = Unit, and add the u_unit field on the report
  6. Save the report and drill into an entry that has data in the u_unit reference field
  7. The image illustrates the last part of the filter has > Unit = (empty) and returns no records



  8. Click in the Unit column and press Enter, you will see that filter change to Unit Unit Number = 1234:



  9. The issue seems to be with having a display field using the same name as the table, and having that as a reference field on any table. Then, reporting on that field using stacked_by to the reference field, the query created for the list view has a problem finding the display field on the referenced table.

 

Workaround

  1. Change the field name to be different from the table
  2. Set the display=true on a different field and not the custom field
  3. If attempting a bar chart, use a different stack by
  4. If attempting a pivot, set the custom field as Column instead of Row

 


Related Problem: PRB689439

Potentially Seen In

There is no data to report.

Fixed In

Rome

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.