I need some help to filter the field Internals array to only show the item with the same _id of this field profile_id using aggregate, but I realy cant get this. I try use filter, lookup and search in many posts. I want using aggregate, to get the documents with filtered array of users based on th…

Thak you Santiago, it works !!! Mongo Playground db.users.aggregate([ { $match: { email: { $in: [ /carlos.aquino/i ] }, active: { $in: [ true, null ] }, deleted: { $in: [ false, null ] } } }, { $sort: { created_at: -1 } }, { $unwind: "$profile" }, { $unwind: "$profile.products" }…

duard_N_A (Duard N/A) July 7, 2021, 9:23am 5

I put the link to mongo playground

Filter an array by the given ID

MongoDB: Filter an array by _id using aggregate