Querying nested arrays in MongoDB & PHP

Question

I'm using MongoDB with PHP's own driver and I have saved multiple arrays under main document. Structure looks like this:

{
 _id: 234234234324,
 accounts: {
    0: {
        enabled: 1,
        name: 'asdf'
    },
    1: {
        enabled: 0,
        name: 'gfsd'
    }
}

Accounts are removed and added by the user so I have no control over the array key. I need to somehow get all accounts that have enabled: 1. I tried array("accounts.enabled"=>1) but it doesn't work. And suggestions?

Andrew Orsich · Accepted Answer · 2011-11-22 11:59:02Z

4

In your schema accounts isn't nested array, it's actually complex object, because of this array("accounts.enabled"=>1) will not work (you actually can check only particular element -> array("accounts.0.enabled"=>1)).

Solution of your problem can be schema redesign as follows:

{
 _id: 234234234324,
 accounts: [
    {
        enabled: 1,
        name: 'asdf',
        id: 0
    },
    {
        enabled: 0,
        name: 'gfsd',
        id: 1
    }]
}

If you will make above changes, your query will work.

answered Nov 22, 2011 at 11:59

Andrew Orsich

53.8k17 gold badges142 silver badges134 bronze badges

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

1 Comment

jimmy Over a year ago

Ok thanks. I don't think it's worth the hassle to do schema redesign at this point. What I can do is to get all docs with accounts and then iterate and get enabled ones. Not very efficient but will work just fine in what we are doing.

Collectives™ on Stack Overflow

Querying nested arrays in MongoDB & PHP

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related