Page 1 of 1

DB Undefined Values Query

Posted: Mon Nov 23, 2020 11:27 pm
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
    }
};[/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?


Re: DB Undefined Values Query

Posted: Mon Nov 30, 2020 3:20 pm
by Serhii Kulibaba

Answered in the ticket #43448


Re: DB Undefined Values Query

Posted: Tue Mar 22, 2022 8:46 pm
by 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: