How to fetch only condition satisfied/match object from an array in mongodb?

Question

I am new to MongoDB.

This is my 'masterpatients' collection it has many documents. every documents contain 'visits' array and every visits array contains multiple objects. I want only those object which is satisfied with my input. I am expecting only below the expected output. if the facility match with my input and visit date range match with my provided input then the query should return only that object as I have given below.

_id:5ef59134a3d8d92e580510fe
    flag:0
    name:"emicon_test"
    dob:2020-06-25T00:00:00.000+00:00
    visits:[
     {
        visit:2020-06-09T10:36:10.635+00:00,
        facility:"Atria Lady Lake"
     },
    { 
       visit:2020-05-09T10:36:10.635+00:00,
       facility:"demo"
    }]
    
    _id:5ee3213040f8830e04ff74a8
    flag:0
    name:"xyz"
    dob:1995-06-25T00:00:00.000+00:00
    visits:[
     {
        visit:2020-05-01T10:36:10.635+00:00,
        facility:"pqr"
        
     },
    {
       visit:2020-05-15T10:36:10.635+00:00,
       facility:"demo"
       
    },
    {  
       visit:2020-05-09T10:36:10.635+00:00,
       facility:"efg"
    }]

My query input parameters is facility='demo' and visit date range is from '1st May 2020' to '10th May 2020'

output expected:

_id:5ef59134a3d8d92e580510fe
    flag:0
    name:"emicon_test"
    dob:2020-06-25T00:00:00.000+00:00
    visits:[
    { 
       visit:2020-05-09T10:36:10.635+00:00,
       facility:"demo"
    }]

Thanks in advance.

@Joe yes but it returns a whole array, not a specific object as I mention output. — Mahendra
– Mahendra, Commented Jul 2, 2020 at 3:24

Mahendra · Accepted Answer · 2020-07-02 05:31:45Z

1

I got an answer.

MasterPatientModel.aggregate([
                {
                    '$unwind':"$visits"
                },
                {"$match": {"visits.visit": {"$gte": new Date(req.body.facilitySummaryFromdate), "$lte": new Date(req.body.facilitySummaryTodate)
                                            } ,  "visits.facility":  req.body.facilitySummary
                           }
                }
    ])

answered Jul 2, 2020 at 5:31

Mahendra

214 bronze badges

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

Comments

Robert Moskal · Accepted Answer · 2020-07-02 11:15:31Z

0

You cannot filter the contents of a mongo collection property on the server.

Make visits array into a top level collection/model and you can filter by criteria on the server.

answered Jul 2, 2020 at 11:15

Robert Moskal

22.7k8 gold badges69 silver badges91 bronze badges

Collectives™ on Stack Overflow

How to fetch only condition satisfied/match object from an array in mongodb?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related