Filtering null [May 01]

:raising_hand_man: 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?

:raising_hand_man: wkw replied

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

:raising_hand_man: David (he/him) replied

that’s the first thing I tried :slight_smile:

:raising_hand_man: wkw replied

please create an issue in github then.

Autogenerated from discord


Join NocoDB’s community

Discord • Twitter • Reddit • Docs