DB Undefined Values Query

[czambrano]

I'm trying to query in the Server Code a Database collection the records that contain an undefined values in a field (date type).

According MongoDB and Appery documentation, I should use the $exists syntax

My sintax is as follows:

Code: Select all

[code]params.criteria = {
    "dateField": {
        "$exists": false
    }
};[/code]

But in the result I get the following:

message: Invalid value for type 'date': 'false'.
code: DBSQ252

Which should be the correct syntax to accomplish the query?

[Serhii Kulibaba]

Answered in the ticket #43448

[blakeadam]

I'm trying to query in the Server Code a Database collection the records that contain an undefined values in a field (date type).

According MongoDB and Appery documentation, I should use the $exists syntax

My sintax is as follows: