Filtering by a specific value does not return results incorrectly

Question

Dynamics CRM 2011 on the premise.

We set up an incident / event object to add new fields and customized views for this object to show some new fields. One of the fields is a link to another object (Benefit in this screenshot:

When I turn on the filters, I get the following options:

All parameters work separately from "Filter by specific advantage ...".

Selecting this option displays this screen:

No matter what is selected, the resulting list is empty, even if it should not be. No error is displayed.

The behavior is the same in the latest IE and the latest Chrome.

How can I research this?

Answer 1

The filter is not applied by value, but by reference. You have several advantages with the same name, but in reality they are different entities. Therefore, if you “select Dental”, it will not filter all “Dental” records, but simply filters for incidents / cases for that particular “Dental” record as an advantage.

If you want to see only those that were dental or hospital or optical, you need to add a set of parameters to your incident / case object, which is basically the name of the assigned benefit record.