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
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 ><
Why don’t you just uncheck the Ignore empty constraints option?
Because I need to search for this
date A is superior to a date OR date A is empty
If you uncheck that option, aren’t you getting both records that match the below condition
together with ALL those with an empty date?
