Hi. I am trying to fetch data in iOS SDK where datetime field is null. I tought it would work with this in the where clause:
dataQuery.whereClause = @"fechaCanje is null";
I am expecting to get one object in response, but i get an empty BackendlessCollection. ¿What should be the right way to search for null datetime values?
Could you check the column type in Backendless Console’ Schema Editor? Does it say string or date?
You’re right, (columnname IS NULL) is not working for me either. I will have to discuss it with the dev team and let you know.
Hi Mark. Do you have any update on this?
This is fixed in the current release. If you use the following “where” clause, it will find all the objects where date-based column is null:
yourColumnName IS null
Thanks Mark. It is working now.