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