Filter by dependent entity

[papermoon]

I know how to add and store filters in list views. But it seems you can only select fields from the current entity and not from dependent entites.

Following example (which probably doesn't make sense, but can explain it very well). I have the list of accounts. Here I need to filter for last name of contacts ... like Doe. So when I enter Doe, I only want to see accounts in the list, a contact named Doe is linked to. Is this possible?

[victor]

Advanced Pack extension is required.

1. Create a List Report with a filter as in screenshot 1.
2. Select the desired Order inside this List Report.
3. Based on this List Report, create a Report Filter https://docs.espocrm.com/user-guide/...report-filters and use it.

However, a more convenient option would probably be to view the Report directly using Runtime Filters.

[papermoon]

Thank you for your answer. But I think I was not clear enough / or maybe I do something wrong using the Report Filters. In my example the last name Doe is not a fixed criteria, instead I want to enter the last name every time I use this filter in the list view (like for normal filters on fields of the current entity). When I use runtime filters in the report, I have no possibility to enter a value in the list view later (so the filter is basically ignored). And when I use a normal filter in the report, the filter is fixed anyway.