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

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.

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.

    

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.