I have a collection in Mongo called ‘collectionX’. I want to query whole data, except I want to filter out by event_date that is after July 1st (event, creationdate – unix milisecond timestamp). However I am using this query in azure data copy tool and I get an error of an invalid use of filtering.
db.CollectionX.find({
"events": {
"$elemMatch": {
"creationDate.$date": { "$gt": NumberLong(1725072000000) }
}
}
})
Tried multiple queries, do I write Mongo queries here or something else?