DB Undefined Values Query

Moderator: Support

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

DB Undefined Values Query

Post by czambrano »

Hello I'm trying to query the records in a DB collection that contains undefined in a date type field.

According to MongoDB I should use the operator $exists, I have the following syntax:

params.criteria = {
"dateField": {
"$exists": false
}
};

I'm getting the following error msg:

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

Which should be the correct syntax to query the records?

Serhii Kulibaba
Posts: 147
Joined: Tue Aug 27, 2013 1:47 pm

Re: DB Undefined Values Query

Post by Serhii Kulibaba »

Answered in the ticket #43448

Post Reply