How to get elements from an array based on condition in MongoDB?

Question

I am the beginner in MongoDB & Here is my sample doc given below :

{
"plan_id" : "100",
"schedule_plan_list" : [ 
    {
        "date" : "01-05-2020",
        "time" : "9:00AM -10:00AM"
    }, 
    {
        "date" : "02-05-2020",
        "time" : "10:00AM -11:00AM"
    }, 
    {
        "date" : "03-05-2020",
        "time" : "9:00AM -10:00AM"
    }, 
    {
        "date" : "04-05-2020",
        "time" : "9:30AM -10:30AM"
    }, 
    {
        "date" : "05-05-2020",
        "time" : "9:00AM -10:00AM"
    }, 
    {
        "date" : "06-05-2020",
        "time" : "9:00AM -10:00AM"
    }, 
    {
        "date" : "07-05-2020",
        "time" : "9:30AM -10:30AM"
    }, 
    {
        "date" : "08-05-2020",
        "time" : "4:00PM -5:00PM"
    }
  ]
}

I want to get next 5 elements ** based on given date is **"02-05-2020"

My given query fetch only match "02-05-2020" but I want "02-05-2020","03-05-2020",.."06-05-2020"

 db.getCollection('schedule_plans').find({"plan_id" : "100"},{_id:0,"schedule_plan_list": { "$elemMatch": { "date" : "02-05-2020"}}})

so anyone help me to solve this

whoami - fakeFaceTrueSoul · Accepted Answer · 2020-05-15 14:48:38Z

5

You can try below aggregation query :

db.collection.aggregate([
{ $match: { "plan_id": "100" } },
/** You can re-create `schedule_plan_list` field with condition applied & slice the new array to keep required no.of elements in array */
{
  $project: {
    _id: 0,
    "schedule_plan_list": {
      $slice: [
        {
          $filter: { input: "$schedule_plan_list", cond: { $gte: [ "$$this.date", "02-05-2020" ] } }
        },
        5
      ]
    }
  }
})

Test : mongoplayground

Ref : aggregation

edited May 15, 2020 at 14:48

answered May 15, 2020 at 14:43

whoami - fakeFaceTrueSoul

18.1k6 gold badges36 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to get elements from an array based on condition in MongoDB?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related