"Ignore empty constraints" and DATE filters?

Need help
1

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

2

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 ><

3

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

4

Because I need to search for this

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

6

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

together with ALL those with an empty date?

7

This topic was automatically closed after 70 days. New replies are no longer allowed.