Mongoose :Find and filter nested array Mongoose :Find and filter nested array mongoose mongoose

Mongoose :Find and filter nested array


node.js filter mongoose nested find

Try below query: 

ListModel.findOne({"_id" : "57e6bcab6b383120f0395aed", 'recipients.status' : 1},{_id:1, name: 1, subject:1,'recipients.$': 1}, function(err,list){...});

node.js filter mongoose nested find

You can use aggregate to get it in an easy way like this

ListModel.aggregate(    { $match: {_id: ObjectId("57e6bcab6b383120f0395aed")}},    { $unwind: '$recipients'},    { $match: {'recipients.status':1}})

Output

{    "_id" : ObjectId("57e6bcab6b383120f0395aed"),    "name" : "Emailing listname",    "subject" : "List subject",    "recipients" : {        "uid" : "57e93266c3c0b1dc1625986f",        "status" : 1    }}

To understand aggregation in details see the docs here

Recent Posts
How can I color dots in a xy scatterplot according to column value?
How to update a claim in ASP.NET Identity?
What does {0} mean when initializing an object?
Accessing members of items in a JSONArray with Java
How to log SQL statements in Spring Boot?
Powershell Get-WebSite name parameter is ignored
How to detect scroll to bottom of html element
Java synchronized method
How to test controllers with CodeIgniter?
Detect Visual Composer
Matplotlib: Specify format of floats for tick labels
Rails join a list of strings with commas and "and" before the last