Comparison and pattern-match repository queries do not return items where the property queried is null. The following queries are the operators of the comparison or pattern-match queries that exhibit this behavior:

=, !=, <, <=, >, >=, CONTAINS, STARTS_WITH, ENDS_WITH

For example, if your query is balance = 101 or balance < 101, the query does not return an item whose balance property is null. However, if your query is balance != 101, the query still does not return an item whose balance property is null.

If you wish your query to return items whose queried property is null, you may use an IS NULL query, or an IS NULL clause as part of an OR query, for example:

(balance != 101) OR (balance IS NULL)