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
Incident State is not Canceled
Caller.Location.Country is USA
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:
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.
Related Problem: PRB1349669