Page 1 of 1

DB Undefined Values Query

Posted: Tue Nov 24, 2020 12:18 am
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?

Re: DB Undefined Values Query

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

Answered in the ticket #43448