Mongodb querying for multiple parameters

Question

I've this collections

{
    "name" : "montalto",
    "users" : [
        {
            "username" : "ciccio",
            "email" : "aaaaaaaa",
            "password" : "aaaaaaaa",
            "money" : 0
        }
    ],
    "numers" : "8",
    "_id" : ObjectId("5040d3fded299bf03a000002")
}

If I want to search for a collection with the name of montalto and a user named ciccio I'm using the following query:

db.coll.find({name:'montalto', users:{username:'ciccio'}}).count()

But it does not work. Where I went wrong?

Ever heard of "embedded documents"?

user2665694
– user2665694

2012-08-31 17:10:34 +00:00
Commented Aug 31, 2012 at 17:10 — user2665694
– user2665694, Commented Aug 31, 2012 at 17:10

JohnnyHK · Accepted Answer · 2014-07-13 14:56:52Z

9

You have to use dot notation to match inside of embedded array objects:

db.coll.find({name: 'montalto', 'users.username': 'ciccio'}).count()

edited Jul 13, 2014 at 14:56

answered Aug 31, 2012 at 15:45

JohnnyHK

313k70 gold badges631 silver badges477 bronze badges

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

2 Comments

Janen R Over a year ago

my code var cursor = db.collection('user-data').find({ "title": title, "author": author }).count();...i just console this cursor variable..but it prints [object promise].doesn't return the count of matched users..any suggestions?

JohnnyHK Over a year ago

@Jana Go ahead and post that as a new question.

Randall Hunt · Accepted Answer · 2012-08-31 16:35:51Z

6

To clarify a collection is a group of documents. So your terminology in this question is slightly off.

To access embedded documents or objects you simply use dot notation as you would in traditional javascript.

db.coll.find({name: 'montalto', 'users.username': 'ciccio'})

You can of course add the .count()on the end of that.

answered Aug 31, 2012 at 16:35

Randall Hunt

12.7k6 gold badges34 silver badges42 bronze badges

Collectives™ on Stack Overflow

Mongodb querying for multiple parameters

2 Answers 2

2 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Related