I need to search through a large mongo collection and find all the documents where updatedAt is at least 7 days after createdAt.
My data looks basically like this:
"createdAt" : ISODate("2021-04-03T10:17:21.256Z"),
"updatedAt" : ISODate("2021-04-03T10:17:21.256Z")
I would appreciate any help.
Use $expr in match. $dateAdd is only available in mongodb 5.0.
db.collection.aggregate([
{
"$match": {
$expr: {
$gt: [
"$updatedAt",
{
$dateAdd: {
startDate: "$createdAt",
unit: "day",
amount: 7
}
}
]
}
}
}
])
604800000 = 7 * 24 * 60 * 60 * 1000
db.collection.aggregate([
{
"$match": {
$expr: {
$gt: [
"$updatedAt",
{
$add: [
"$createdAt",
604800000
]
}
]
}
}
}
])
use $where
db.collection.find({
"$where": "this.updatedAt > new Date(this.createdAt.getTime() + 604800000)"
})