Filters looks very limited (at least for newbie)

Help
,
1

Hello!

I am trying directus for my setup and it feels like I cannot do several basic things. I would appretiate you much for any tips and suggestions.

  1. Item from collection “profile” has O2M field “invoices”. How to set this field in admin panel to show only invoices that have paid==false ? I cannot find any “filters” in UI (see screnshot).

  2. I am strugling with filters syntax as well (in flow builder UI): is it possible to compare element’s field with another element’s field. Let’s say I want to do following for example: select all items from collection “profiles” that has field “current” bigger than field “limit” for more than 5? (I know that I could do it by passing all items to scrip at filtering them there, but it smells like dirty w/a).

  3. Screenshot_20260217-154543
    Screenshot_20260217-1545431080×1380 68.5 KB

2

@Alex_sf

For the O2M field in the admin panel, open the invoices field inside the profile collection, go to its Interface settings, and there you can define a filter (e.g., paid equals false) so only unpaid invoices are shown in the relation. Alternatively, you can create a global bookmark with that filter, so when selecting invoices it will only show unpaid ones.

Regarding Flow filters, the UI is a bit limited and doesn’t support comparing one field to another (like current > limit) directly. For that kind of logic, you’ll usually need a Run Script step or handle it at the database level (for example, using a view).