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

DB Undefined Values Query

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

Re: DB Undefined Values Query

Answered in the ticket #43448

blakeadam
Posts: 2
Joined: Tue Mar 22, 2022 8:43 pm

Re: DB Undefined Values Query

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:

Return to “Issues”