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, Jun 24 '16 at 06:24
you want to find out those amenities who has price & is_free both — Chetan Kumar, Jun 24 '16 at 06:29
Price and is_free doesn't matter. I want the place which are having amenities like 'wifi' and 'projector'. — Akhil P, Jun 24 '16 at 06:31
I have modified the question. Please have a look. @Shrabanee — Akhil P, Jun 24 '16 at 06:33
Possible duplicate of [How to search in array of object in mongodb](http://stackoverflow.com/questions/14040562/how-to-search-in-array-of-object-in-mongodb) — aarosil, Jun 24 '16 at 06:38
I just want to know will it work for more than one `$elemMatch`. @aarosil — Akhil P, Jun 24 '16 at 06:40
I am assuming that you have a collection 'places' in whose documents, you have an embedded array 'amneties'. And you want to find only those places in which 'amneties' exist. Is it what you need? — Manish Kapoor, Jun 24 '16 at 06:46

Manish Kapoor · Accepted Answer · 2016-06-24T08:35:10.130

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 '16 at 08:35

answered Jun 24 '16 at 06:49

Manish Kapoor

488
3
16

not only having amenities. But it should have specific amenities. Your answer will not solve my problem – Akhil P Jun 24 '16 at 06:51
Find those places which have all ameneties specified in an array like: ['wifi', 'loudspeakers', 'phone']. Is it what you need? – Manish Kapoor Jun 24 '16 at 06:57
Yes! That is what I want. But your query doesn't do that. It will search only amenities filed exists or not. – Akhil P Jun 24 '16 at 08:19
1

@AkhilP, the question was not explanatory enough. However, I have edited my answer. Please have a look if it helps. – Manish Kapoor Jun 24 '16 at 08:29
I think it will work without `$and` also. Just use the two conditions two find. – Shrabanee Jun 24 '16 at 10:40

Shrabanee · Answer 2 · 2016-06-24T09:40:32.990

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 '16 at 09:40

answered Jun 24 '16 at 06:55

Shrabanee

2,706
1
18
30

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. – Akhil P Jun 24 '16 at 08:06
Updated the query as per your requirement. I think your question is not clear enough to let someone help you in one go. – Shrabanee Jun 24 '16 at 09:51

score 1 · Answer 3 · edited Jun 24 '16 at 07:24

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 '16 at 07:24

profesor79

9,213
3
31
52

answered Jun 24 '16 at 07:22

Rubin Porwal

3,736
1
23
26

1

have in mind that this will return only first matched element `elemMatch` specific :-) – profesor79 Jun 24 '16 at 07:24
1

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']` – Akhil P Jun 24 '16 at 07:48

How to query Mongodb for embedded array

3 Answers3