BUG with "is empty" filter on rows where linked record was deleted

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.

I can confirm and have created a proper issue for it: Is empty filter on Link to table field doesn't work correctly after linked items are deleted (#1864) · Issues · Baserow / baserow · GitLab

2 Likes