query for empty datetime field

Data Service
1

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?

2

Could you check the column type in Backendless Console’ Schema Editor? Does it say string or date?

Regards,
Mark

3

Datetime

4

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.

5

Ok, thanks Mark.

6

Hi Mark. Do you have any update on this?

Regards,
Andrés

7

Hi Andrés,

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

Regards,
Mark

8

Thanks Mark. It is working now.

Regards,
Andrés