How to find all in an array of array in MongoDB

Question

Below is the schema for an array contacts. The contacts array has a field hashtag which is another array. How do I find all the contacts which have a particular hashtag? For example all contacts with hashtag "zxc"?

"contacts" : [
    {
        "addedDate" : ISODate("2015-12-02T09:06:09.891Z"),
        "personEmailId" : "[email protected]",
        "_id" : ObjectId("565eb481bf35eeb83d7f9f13"),
        "verified" : true,
        "favorite" : true,
        "linkedinUserName" : null,
        "facebookUserName" : null,
        "twitterUserName" : "IamlifePaul",
        "count" : 2,
        "relationshipStrength_updated" : 0,
        "contactRelation" : {
            "decisionmaker_influencer" : null,
            "prospect_customer" : "prospect"
        },
        "source" : "abc",
        "mobileNumber" : "3546789",
        "skypeId" : "123",
        "designation" : "test",
        "companyName" : "Something",
        "location" : "Hyderabad, Telangana, India",
        "personName" : "Naveen Paul",
        "personId" : "565022d7dbeaeb9e17fc7083",
        "hashtag" : [

            "latestTag",
            "anotherTag",
            "#hash",
            "openLove",
            "hellTwo",
            "working?",
            "hello",
            "lol",
            "zxc"
        ],
        "lastInteracted" : ISODate("2015-12-08T05:07:53.746Z")
    },
{
        "addedDate" : ISODate("2015-12-02T09:06:09.891Z"),
        "personEmailId" : "[email protected]",
        "_id" : ObjectId("565eb481bf35eeb83d7f9f13"),
        "verified" : true,
        "favorite" : true,
        "linkedinUserName" : null,
        "facebookUserName" : null,
        "twitterUserName" : "IamlifePaul",
        "count" : 2,
        "relationshipStrength_updated" : 0,
        "contactRelation" : {
            "decisionmaker_influencer" : null,
            "prospect_customer" : "prospect"
        },
        "source" : "abc",
        "mobileNumber" : "3546789",
        "skypeId" : "123",
        "designation" : "test",
        "companyName" : "Something",
        "location" : "Hyderabad, Telangana, India",
        "personName" : "Naveen Paul",
        "personId" : "565022d7dbeaeb9e17fc7083",
        "hashtag" : [

            "latestTag",
            "anotherTag",
            "#hash",
            "openLove",
            "hellTwo",
            "working?",
            "hello",
            "lol",
            "zxc"
        ],
        "lastInteracted" : ISODate("2015-12-08T05:07:53.746Z")
    },
{
        "addedDate" : ISODate("2015-12-02T09:06:09.891Z"),
        "personEmailId" : "[email protected]",
        "_id" : ObjectId("565eb481bf35eeb83d7f9f13"),
        "verified" : true,
        "favorite" : true,
        "linkedinUserName" : null,
        "facebookUserName" : null,
        "twitterUserName" : "IamlifePaul",
        "count" : 2,
        "relationshipStrength_updated" : 0,
        "contactRelation" : {
            "decisionmaker_influencer" : null,
            "prospect_customer" : "prospect"
        },
        "source" : "abc",
        "mobileNumber" : "3546789",
        "skypeId" : "123",
        "designation" : "test",
        "companyName" : "Something",
        "location" : "Hyderabad, Telangana, India",
        "personName" : "Naveen Paul",
        "personId" : "565022d7dbeaeb9e17fc7083",
        "hashtag" : [

            "polly",
            "tagger",
            "#hash",
            "working?",
            "hello",
            "lol",
            "zxc"
        ],
        "lastInteracted" : ISODate("2015-12-08T05:07:53.746Z")
    }

I did this query - db.myColl.find({"contacts.hashtag":"zxc"},{"contacts":{$elemMatch:{"hashtag":"zxc"}}}).pretty() which returned only one contact. I need to get all contacts.

which modeling package do you use here? mongoose?

Rodion
– Rodion

2015-12-09 11:12:40 +00:00
Commented Dec 9, 2015 at 11:12 — Rodion
– Rodion, Commented Dec 9, 2015 at 11:12
Yes, I'm using Mongoose.

Naveen Paul
– Naveen Paul

2015-12-09 11:52:36 +00:00
Commented Dec 9, 2015 at 11:52 — Naveen Paul
– Naveen Paul, Commented Dec 9, 2015 at 11:52

hecnabae · Accepted Answer · 2015-12-09 11:40:08Z

1

You can do it via aggregation framework:

1) Do an initial match to reduce the input set for aggregation

2) Unwind contacts field.

3) Filter out contacts with hashtag 'zxc'

4) Group by id and put contacts on "contacts" field.

db.getCollection('contacts').aggregate([
    {$match: {"contacts.hashtag":"zxc"}},
    {$unwind: "$contacts"},
    {$match: {"contacts.hashtag":"zxc"}},
    {$group: {_id:"$_id", "contacts": {$push:"$contacts"}}}
])

edited Dec 9, 2015 at 11:40

answered Dec 9, 2015 at 11:22

hecnabae

4074 silver badges21 bronze badges

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

1 Comment

Naveen Paul Over a year ago

Works like a charm. Thank you.

sahil gupta · Accepted Answer · 2015-12-09 11:34:50Z

0

You can use

For multiple hashtag in single doc

db.myColl.find({"contacts.hashtag":{$in : ['zxc','anotherTag']}});
//will return all doc with any of the two hashtags.

For single hashtag

   db.myColl.find({"contacts.hashtag":'zxc'});
  //return all documents with hashtag 'zxc'

Please refer $in

edited Dec 9, 2015 at 11:34

answered Dec 9, 2015 at 11:26

sahil gupta

2,34914 silver badges14 bronze badges

3 Comments

Naveen Paul Over a year ago

This returns all the documents. Even without the hashtags.

sahil gupta Over a year ago

Without the hashtags means a document without the hashtags property?? Above will not return those document !! Please explain?

Naveen Paul Over a year ago

Its returning all the contacts without the hashtag ''zxc" or without the hashtag property. Coz some contacts don't have any hashtags and thus the hashtag field is not yet created for them.

Collectives™ on Stack Overflow

How to find all in an array of array in MongoDB

2 Answers 2

1 Comment

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related