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.
List V2: For a fixed query with an OR Condition to which Group by is applied, the list shows unexpected results - Known Error
  • >
  • Knowledge Base
  • >
  • Known Error (Knowledge Base)
  • >
  • List V2: For a fixed query with an OR Condition to which Group by is applied, the list shows unexpected results
KB0623775

List V2: For a fixed query with an OR Condition to which Group by is applied, the list shows unexpected results


2051 Views Last updated : Jul 27, 2023 public Copy Permalink
KB Summary by Now Assist

Description

When there is a fixed query on a table and the query contains an OR condition, if Group By is applied on a field, the list shows unexpected results.

Steps to Reproduce

  1. Navigate to Incident > All.

  2. Make sure that there are at least a few incidents with Caller as two or more different users.

  3. Click the filter icon and add the filter [Caller][is][Bow Ruggeri] (or any other user having multiple incidents).

  4. Click the OR button at the top. (DO NOT use the one on the side of the filter you added.)

  5. Add the filter [Caller][is][Bud Richman] (or any other user having multiple incidents).

  6. Modify the URL parameter from "sysparm_query" to "sysparm_fixed_query" and reload the page.

    Note that the filter is no longer changeable.

  7. Right-click on the State field and choose Group By.

    The list will be grouped as usual, with a group for each state, but, under each group, incidents from multiple states will be displayed rather than incidents from only that state.

     

Workaround

The problem ticket associated with this Known Error has been reviewed by ServiceNow. After careful consideration of the severity of the issue and the risk of attempting a fix, we have decided not to address this issue in a current or future release.

We did not make this decision lightly and apologize for any inconvenience.

 


Related Problem: PRB1093125

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?

Attachments

Attachments

  • GroupBy_and_fixed_query.png
  • GroupBy_and_fixed_query.png
  • GroupBy_and_fixed_query.png

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.