Dropping a dot-walked field from the last filter clause in Report Designer drops both fields when they are the same dot-walked field - Known Error

Dropping a dot-walked field from the last filter clause in Report Designer drops both fields when they are the same dot-walked field Description When a report filter ends in an OR condition containing the same dot-walked field twice, dropping either one of the fields will drop both from the filter conditions, rather than only one as desirable.

Steps to Reproduce

This example uses specific fields, but you could use any first two non dot-walked fields in the beginning and any dot-walked field for the 3rd and 4th condition.

1. Create a report using the Report Designer instead of the Classic UI on the incident table with the following filter conditions: Active is True AND Incident State is not Canceled AND Caller.Location.Country is USA OR Caller.Location.Country is France

2. Save the report.

3. Drop either the 3rd or 4th condition.

Notice only the first two filter conditions reman, and the two dot-walked fields are removed from the filter:

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 this decision lightly, and we apologise for any inconvenience.

The workaround is to use the Classic Report Builder UI, or to reorganise the filter sequence, mindful of the fact that multiple conditions are removed in the Report Designer when the last conditions are on the same dot-walked field.