Data Provider' Filter for Boolean type fields stopped working

[sergey-dme]

Hi All,

v. 0.9.78

Data Provider' Filtering by Date/Time stopped working across all my apps. Returns always 0 records.
No changes in formulas/fields/records were made. Even tried with the only Date/Time filed.

This is example where formula is using:

P.S. It doesn't matter if an app is existing or re-imported.

Please solve the issue.

[aptkingston]

@sergey-dme your filter looks correct. I just tried this myself in a fresh app and it works perfectly:

Your data provider is still spinning in the screenshot - is it still loading? Either it is being extremely slow or an error has happened, because it would not be spinning like that when there are 0 rows. Does it spin forever or does it stop? Is there an error in the console when you open dev tools?

[sergey-dme]

@aptkingston Actually the bug with Boolean Type field. Once I removed this condition with Boolean filed filtering It started worked again. It's not related to Date/Time field.

Let's recreate a behavior/issue in a new app:

There is just a simple Table with three columns and two records. Option1 is a Boolean type filed:

Again, the records we have (no filter used):

If we start using filtering for Option1 field (Boolean) it returns 0!
It should return 1 record in this case:

It was working in previous versions.

[sergey-dme]

Just found:
#2030
#2042

[aptkingston]

@sergey-dme now that this issue is linked, I'm going to close this one as it's a duplicate. You can keep track of the progress in the existing issues. Thanks for the extra detail though.

[aptkingston]

@sergey-dme I'm reopening this becaue it's actually a separate issue. I had fixed boolean filtering on data providers already, so something else must have changed here without me realising. This definitely used to work.