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

Supabase

In a varchar field I have some records that are NULL and some that are EMPTY.  I can create a filter to show all the records where that IS null.  But I can't figure out how to do the same if the field is EMPTY.  I get an 'invalid query' error if I enter `empty` or `EMPTY`.

Hello <@343093561777979393>!
This thread has been automatically created from your message in <#843999948717555735> a few seconds ago.

We have already mentioned the <@&951828363943759883> so that they can see your message and help you as soon as possible!

**Want to unsubscribe from this thread?**
Right-click the thread in Discord (or use the ``...`` menu) and select "Leave Thread" to unsubscribe from future updates.

**Want to change the title?**
Use the ``/title`` command!

**We have solved your problem?**
Click the button below to archive it.

🆕 How do I filter for EMPTY fields in Records?

You test against '' (two single quotes) for empty.
https://stackoverflow.com/questions/23766084/best-way-to-check-for-empty-or-null-value

How do I filter for EMPTY fields in Records?

<@764524500162445402> that doesn't return anything with null or empty in the field.

When I remove the filter I see results like this... where you can see the EMPTY values in the address column.

I presumed you were doing api calls with the filter...  I'm not sure what the UI does.  It is tricky even for default values.

If I change the comparison to 'is' and type `null` in the value.  I see all the records with 'NULL' but none of the 'EMPTY' values.

If I try to enter `EMPTY` or `empty` instead of `null` I get a query error.

to get the UI to set default to empty for a string have to do this: format('')   but that does not seem to work in the filter box

Yeah, it's strange, I don't know what 'EMPTY' means in that context instead of null.  That it is a string but it doesn't have characters, where 'null' isn't even defined as a string yet?

null means nothing there.  empty means you have '' string there.

select * from messages where message2 = ''  works in the sql editor....

I'm going to go with... you can't at this point.  Might be worth opening an issue on it.

<@764524500162445402> I found it... You have to filter where the field is less than 1.

Thread was archived by <@343093561777979393>. Anyone can send a message to unarchive it.