Supabase is an open source Firebase alternative. Start your project with a Postgres database, Authentication, instant APIs, Edge Functions, Realtime subscriptions, and Storage.

Supabase

Hi all, why doesn't this basic query work?
```
const { data, error } = await supabase
    .from("actions")
    .select()
    .not("status", "eq", "complete")
```
I have a column of status (type varchar) and the default value of the column is NULL (which is my only guess as to why this isn't working). When i remove the not filter, I get my data back so it's not that there's another general error like my keys not working or something. I also have had another filter working,  which I'm trying to combine with this one, but removed for the sake of debugging.

Try  .is('status', null) if that is what you want

Ah gotcha, thanks. And no that won't work because I still want actions with other statuses, just not complete.

I think I'm gonna look into setting up enums for this anyway and that'll help me avoid it plus keep things more manageable

<@!208640150991929346>  you could also probably do a .or with both as an option.