Question 116382 in Mongodb Question posted in
The official documentation can be found here.

MongoDB view with dynamic dates

I am trying to create a view for records created/modified in last 24 hours.
Is it possible?

Tried creating view as below

db.createView(
   "viewname",
     "sourcecollection",
   [ { $match: {"modifiedTime":{$gte:new Date(Date.now() - 24*60*60*1000), $lte:new Date()}}}]
)

But it translates to static values

{
  modifiedTime: {
    $gte: ISODate('2022-10-25T23:20:21.602Z'),
    $lte: ISODate('2022-10-26T23:20:21.602Z')
  }
}

Did read about $$NOW but could not get it working in create view command.
Please suggest

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    Based on above post, got it working in Mongo 4.4 with below command. Dynamic view for records in last 24 hours.

    db.createView(
   "viewname",
   "source",
   [ { $match: {$expr: { $gte: [ "modifiedTime" , { $subtract: [ "$$NOW", 24*60*60*1000 ] } ] }}}]
)

  2. 0

    Try this one:

    db.createView(
   "viewname",
   "sourcecollection",
   [
      {
         $match: {
            $expr: {
               $and: [
                  { $gte: ["$modifiedTime", { $dateSubtract: { startDate: "$$NOW", unit: "day", amount: 1 } }] },
                  { $lte: ["$modifiedTime", "$$NOW"] }
               ]
            }
         }
      }
   ]
)
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search