I have 2 tables, for example:
1 — Odrers
2 — Orderered items (where each row has linked to “Orders”)
So… when I delete rows from “Orders” and want to see all records from “Ordered items” which doesn’t have linked “Order”. → I use “is empty” filter applied to corresponding field and… don’t get anything.
Even if I cleanup deleted “Order” rows from “Trash”.
But if I create new rows in “Ordered items” without linked items from “Orders” table → this filter works as expected.