DB Undefined Values Query

Moderator: Support

Posts: 3
Joined: Mon Nov 23, 2020 10:53 pm

DB Undefined Values Query

Post by 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

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
Posts: 149
Joined: Tue Aug 27, 2013 1:47 pm

Re: DB Undefined Values Query

Post by Serhii Kulibaba »

Answered in the ticket #43448

Post Reply