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

**URL:** <https://community.baserow.io/t/bug-with-is-empty-filter-on-rows-where-linked-record-was-deleted/3149>\
**Category:** Technical Help\
**Created:** [July 20, 2023, 12:12pm UTC](https://community.baserow.io/t/bug-with-is-empty-filter-on-rows-where-linked-record-was-deleted/3149 "2023-07-20T12:12:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![levinside](https://community.baserow.io/user_avatar/community.baserow.io/levinside/32/1469_2.png) [@levinside](https://community.baserow.io/u/levinside)\
**Post date:** [July 20, 2023, 12:12pm UTC](https://community.baserow.io/t/bug-with-is-empty-filter-on-rows-where-linked-record-was-deleted/3149/1 "2023-07-20T12:12:42Z")

</div>

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.

 ![SCR-20230720-ndia](https://community.baserow.io/uploads/default/original/2X/e/e2bdb8612b5bab01fd5f17270d53cd9d456ba93d.png)

---

<div class="post-metadata">

**Author:** ![petrs](https://community.baserow.io/user_avatar/community.baserow.io/petrs/32/159_2.png) [@petrs](https://community.baserow.io/u/petrs)\
**Post date:** [July 20, 2023, 2:56pm UTC](https://community.baserow.io/t/bug-with-is-empty-filter-on-rows-where-linked-record-was-deleted/3149/2 "2023-07-20T14:56:48Z")

</div>

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](https://gitlab.com/baserow/baserow/-/issues/1864)
