Accessing array in a mongoDB collection

Question

I have a collection as follows:

{ "_id" : ObjectId("4c9c63a95d765f996ca8dff4"), "count" : "28", "id" : "5565", "person" : [
    {
        "id" : "5435df",
        "name" : {
            "fn" : "abc",
            "ln" : "xyz"
        },
        "sex" : "m",
        "location" : {
            "country" : "india"
        }

    },
    {
        "id" : "dfg434",
        "name" : {
            "fn" : "def",
            "ln" : "pqr"
        },
        "sex" : "f",
        "location" : {

            "country" : "india"
        }

    }
.
.
.

]
}

the person is an array, with mentioned fields. i wish to find people with a particular id AND country. only those "people" records should be returned. How do i go about doing that? I am using java. Is the structure correct? Should I change the array structure, into something else?

thanks.

EDIT: How do access rules change when brackets change, in this case, i have used [], where i could have used {}. what changes?

sdot257 · Accepted Answer · 2010-09-24 23:52:57Z

2

See "Array" header

answered Sep 24, 2010 at 23:52

sdot257

10.4k27 gold badges95 silver badges128 bronze badges

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

3 Comments

Swapnil Sonawane Over a year ago

that did not help :( do you have another example (in java)? or maybe a bug on jira to show that its not possible? TIA

Swapnil Sonawane Over a year ago

Using a forEach for each nesting of array works. but what I wish, is to return a particular block, when some data inside it is what i want. eg: person.country== "india" should return blocks with id:5435df and id: dfg434.

sdot257 Over a year ago

In that case you're going to want to put them into an array. See this thread I open with the developers on their forum. groups.google.com/group/mongodb-user/browse_thread/thread/…

42n4 · Accepted Answer · 2012-11-20 12:55:48Z

0

Maybe try aggregate from mongo v2.2+ :

    fagg=db.collection.aggregate([{$unwind: "$person"},
    {$project: {name:"$person.name",sex:"$person.sex"}},
    {$match: {sex: "f"}}])

    fagg.result.forEach(function(o){
    db.person.insert({name: o.name, sex: o.sex})})

answered Nov 20, 2012 at 12:55

42n4

1,32922 silver badges26 bronze badges

Collectives™ on Stack Overflow

Accessing array in a mongoDB collection

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related