Aggregate in an Array MongoDB

Question

I would like to aggregate $match on the data inside the array object:

{ example: [{target: "1"}] }

I have tried $match, $elemMatch, $arrayEleAt but I dont know how to write the correct syntax.

{ $lookup: { from: "example", localField: "user_id", foreignField: "user_id", as: "example" } },

    {
        $match: {
            "start_date": { $gte: new Date(startDate) },
            "end_date": { $lte: new Date(endDate) },
            "type": Type,
            "target": "1"

        },
    },

    { $sort: { startDate: 1 } },

Tom Slabbaert · Accepted Answer · 2019-05-10 09:07:31Z

1

Just write it like this:

{
    $match: {
        "start_date": { $gte: new Date(startDate) },
        "end_date": { $lte: new Date(endDate) },
        "type": Type,
        "example.target": "1"

    },
},

answered May 10, 2019 at 9:07

Tom Slabbaert

22.5k10 gold badges34 silver badges45 bronze badges

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

3 Comments

Michael Wybraniec Over a year ago

Yes, I found out thank you. But I added $unwind able to match this way because lookup inserts object into an Array. { $lookup: { from: "example", localField: "user_id", foreignField: "user_id", as: "example" } }, { $unwind: "$example" }, { $match: { "start_date": { $gte: new Date(startDate) }, "end_date": { $lte: new Date(endDate) }, "type": Type, "example.target": "1" }, },

Tom Slabbaert Over a year ago

so it works for you?, if not edit your question to match your full query and ill try to help.

Michael Wybraniec Over a year ago

Yes, thank you Tom, it does. I have had to use $unwind to remove the array. Thank you.

Collectives™ on Stack Overflow

Aggregate in an Array MongoDB

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related