How to query Mongodb for embedded array

Question

I have a mongodb structure like.

The structure of the place model

{.....
  amenities: [
    {
      name: "wifi",
      is_free: true
    },
    {
      name: "projector",
      is_free: false,
      price: "50"
    },
    ...........
    ...........
    ...........
  ]
.....}

I want to do a query where, I want to search for a place which is having some set of amenities exist in the place irrespective of the price & is_free fields. How can I do it inside the mongodb / mongoose query.

I want list of places which are having set of amenities like wifi and projector as a output.

Your question is not clear. So what you have tried and expected result. — Shrabanee
– Shrabanee, Commented Jun 24, 2016 at 6:24
you want to find out those amenities who has price & is_free both — Chetan Kumar
– Chetan Kumar, Commented Jun 24, 2016 at 6:29
Price and is_free doesn't matter. I want the place which are having amenities like 'wifi' and 'projector'. — Akhil P
– Akhil P, Commented Jun 24, 2016 at 6:31
I have modified the question. Please have a look. @Shrabanee — Akhil P
– Akhil P, Commented Jun 24, 2016 at 6:33
Possible duplicate of How to search in array of object in mongodb — aarosil
– aarosil, Commented Jun 24, 2016 at 6:38

Manish Kapoor · Accepted Answer · 2016-06-24 08:35:10Z

4

db.places.find({$and: [{'amenities.name': 'wifi'}, {'amenities.name':'projector'}])

It will find the places which have all amneties specified in an array ['wifi', 'projector'].

Hope it helps.

edited Jun 24, 2016 at 8:35

answered Jun 24, 2016 at 6:49

Manish Kapoor

5563 silver badges18 bronze badges

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

5 Comments

Akhil P Over a year ago

not only having amenities. But it should have specific amenities. Your answer will not solve my problem

Manish Kapoor Over a year ago

Find those places which have all ameneties specified in an array like: ['wifi', 'loudspeakers', 'phone']. Is it what you need?

Akhil P Over a year ago

Yes! That is what I want. But your query doesn't do that. It will search only amenities filed exists or not.

Manish Kapoor Over a year ago

@AkhilP, the question was not explanatory enough. However, I have edited my answer. Please have a look if it helps.

Shrabanee Over a year ago

I think it will work without $and also. Just use the two conditions two find.

profesor79 · Accepted Answer · 2016-06-24 07:24:33Z

1

Please try executing following query

db.places.find({
    amenities : {
        $exist : true
    },
    amenities : {
        $elemMatch : {
            name : {
                $in : ['wifi', 'projector']
            }
        }
    }
})

In above mentioned query $exists operator will check for existence of amenities field in document and $elemMatch operator will match amenities array containing name field with following values

(1) wifi

(2) projector

edited Jun 24, 2016 at 7:24

profesor79

9,5033 gold badges36 silver badges53 bronze badges

answered Jun 24, 2016 at 7:22

Rubin Porwal

3,8451 gold badge27 silver badges27 bronze badges

2 Comments

profesor79 Over a year ago

have in mind that this will return only first matched element elemMatch specific :-)

Akhil P Over a year ago

It is returning documents which are matching at least one amenity in the $in : ['wifi', 'projector']. But I want documents which must have bothe ['wifi', 'projector']

Shrabanee · Accepted Answer · 2016-06-24 09:40:32Z

1

Try below query for one option of name:

db.places.find({amenities: {$exists: true}, 'amenities.name':'wifi'})

Also can try this query, if multiple options to check for name:-

var findQuery = {amenities: {$exists: true}, 'amenities.name':'wifi' , 'amenities.name':'projector'}

db.places.find(findQuery);

Hope this will help you.

edited Jun 24, 2016 at 9:40

answered Jun 24, 2016 at 6:55

Shrabanee

2,7861 gold badge21 silver badges32 bronze badges

2 Comments

Akhil P Over a year ago

It doesn't solve my problem. Please have a look at multiple options it is resulting an empty array. Even my database is having matches with the query.

Shrabanee Over a year ago

Updated the query as per your requirement. I think your question is not clear enough to let someone help you in one go.

Collectives™ on Stack Overflow

How to query Mongodb for embedded array

3 Answers 3

5 Comments

2 Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

5 Comments

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related