Comparing Queries with a Zero Field

Question

My Firestore collection has documents with a string field that can be null.

I expected if I ask:

Collection("products").Where("producedDate", "<", "2018-01-15")

I would get all products whose "createdDate" was earlier than "2018-10-15", including those whose "createdDate" is null.

But actually I do not get nulls.

Is this scheduled or is it a mistake?

Answer 1

He had to work that way. The documentation states that:

, Cloud Firestore , . :

• ,
• [...]

, , . Date, , Date , (, null ).

null, , Where:

Collection("products").Where("producedDate", "<", "2018-01-15").Where("producedDate", "==", null)