# Filtering null \[May 01\]

**URL:** <https://community.nocodb.com/t/filtering-null-may-01/407>\
**Category:** Discord-Discussions\
**Created:** [November 3, 2022, 9:28am UTC](https://community.nocodb.com/t/filtering-null-may-01/407 "2022-11-03T09:28:29Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:28am UTC](https://community.nocodb.com/t/filtering-null-may-01/407/1 "2022-11-03T09:28:29Z")

</div>

> 🙋‍♂️ **David (he/him)** _asked_

## Question, I have a table that has a column that is a linked record type to another table. I want a view such that I filter only those rows for which the linked record column is null. I add a filter for that column being null, and I get no results. But I should get results, since they are all null. I try a filter for the field being empty, no results. The only filter that shows results is when the field is “not like” anything and “not eq” anything. What am I doing wrong?

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:28am UTC](https://community.nocodb.com/t/filtering-null-may-01/407/2 "2022-11-03T09:28:30Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### there is an operator called `is null`. You should use this for checking null columns

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:28am UTC](https://community.nocodb.com/t/filtering-null-may-01/407/3 "2022-11-03T09:28:32Z")

</div>

> 🙋‍♂️ **David (he/him)** _replied_

#### that’s the first thing I tried 🙂

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:28am UTC](https://community.nocodb.com/t/filtering-null-may-01/407/4 "2022-11-03T09:28:33Z")

</div>

> 🙋‍♂️ **wkw** _replied_

#### please create an issue in github then.

#

---

<div class="post-metadata">

**Author:** ![NocoDB](https://avatars.discourse-cdn.com/v4/letter/n/6f9a4e/32.png) [@NocoDB](https://community.nocodb.com/u/NocoDB)\
**Post date:** [November 3, 2022, 9:28am UTC](https://community.nocodb.com/t/filtering-null-may-01/407/5 "2022-11-03T09:28:34Z")

</div>

[Autogenerated from discord](https://discord.com/channels/661905455894888490/969700317946077264)

* * *

#### Join [NocoDB’s](http://www.nocodb.com/) community

[Discord](https://discord.gg/5RgZmkW) • [Twitter](https://twitter.com/nocodb) • [Reddit](https://www.reddit.com/r/NocoDB/) • [Docs](https://docs.nocodb.com/)