Hi everyone,
I’m facing an issue where the ‘Is Null’ condition is not working as expected in my app.
Up until yesterday, it was correctly returning true when no record existed in the model. However, from yesterday onward, it started returning false even when the record is clearly not present.
Nothing significant has changed in my logic or data model that I’m aware of. Has anyone experienced this issue recently? Could this be due to a platform update or caching issue?
Any suggestions or troubleshooting tips would be appreciated!
Project ID : 499936
There was a long outstanding bug regarding inconsistent results of DB Search blocks: when no records found in result set, it mistakenly throwed error to the upper level of system logic that led to null value in Data field.
Starting from last update we’ve fixed that and now DB Search blocks return empty array in Data field if nothing found and that’s a standard proper behavior of the block.
There is a flaw in your logic since you’ve checked result for null only. The best way is to check _success
first to make sure that request executed correctly (no issues with underlying infrastructure/network/db itself) and after that check number of records in count
field.