"Ignore empty constraints" and DATE filters?

bonjour_17 · 2025-04-15T08:34:07.854Z

Hi, while working on some king of task management app, I need to do a search for things where :

date A is superior to a date OR date A is empty

I went for a : “Do a search for X where date A > date” and checked the “Ignore empty constraints” box.

→ this returns only the objects where date is not empty and match the condition. I do NOT get all objects where date is null.

Why?

How would you work around that?

My thoughts : I’ll do 2 searchs, 1 for each of my conditions, and concatenate the results into 1 list.

Thanks

mitchbaylis · 2025-04-15T09:41:14.299Z

bubble has an odd way of handling dates

dates are never “null”
they will show as empty in the backend
but the data is actually always 1 jan 1970

they do this to avoid null errors but it creates other issues especially when using date comparisons like ><

ademiguel · 2025-04-15T09:41:37.924Z

Why don’t you just uncheck the Ignore empty constraints option?

bonjour_17 · 2025-04-15T09:43:47.390Z

bonjour_17:

date A is superior to a date OR date A is empty

Because I need to search for this

date A is superior to a date OR date A is empty

ademiguel · 2025-04-15T09:49:14.829Z

If you uncheck that option, aren’t you getting both records that match the below condition

bonjour_17:

date A is superior to a date

together with ALL those with an empty date?

bonjour_17:

this returns only the objects where date is not empty and match the condition. I do NOT get all objects where date is null.