Array query and return

Question

My first adventure into Mongo. Please save me some time by answering the following. This is the schema.

"_id" : 1,
  "FullName" : "Full Name",
  "Email" : "[email protected]",
  "FacebookId" : NumberLong(0),
  "LastModified" : ISODate("2012-04-11T09:26:10.955Z"),
  "Connections" : [{
      "_id" : 7,
      "FullName" : "Fuller name",
      "Email" : "[email protected]",
      "FacebookId" : NumberLong(0),
      "LastModified" : ISODate("0001-01-01T00:00:00Z")
    },

  ....

Given an id of a single top user, i'd like to return all of the Emails in the Connections array, and preferably, just the emails. What's the querystring? Much obliged!

Christian P · Accepted Answer · 2012-04-11 17:48:59Z

1

You can't get only values from the sub-objects in MongoDB.

If you do a query like this:

db.test.find({"_id": 1}, {"Connections.Email":1});

you will get this kind of response:

{ 
  "_id": 1, 
  "Connections" : [ {"Email":"[email protected]"}, 
                    {"Email":"[email protected]"} ] 
}

This is the closest you can get with a simple query and field selection from MongoDB.

You can then filter out the e-mails values in your code with a simple foreach.

answered Apr 11, 2012 at 17:48

Christian P

12.3k6 gold badges64 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

Array query and return

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related