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.



This issue is under review. To receive notifications when more information is available, subscribe to this Known Error article by clicking the Subscribe button at the top right of the article. If you are able to upgrade, review the Fixed In field to determine whether any versions have a permanent fix.


Related Problem: PRB1093125

Seen In

There is no data to report.

Associated Community Threads

There is no data to report.

Article Information

Last Updated:2019-05-21 11:43:05