Mongoose / Mongo find in array

Question

In MongoDB/Mongoose i have a Server collection which got this element ...

  owners: [{

    type: String,
    ref: 'User'

  }]

The owners array contains many id linked to an User collection. Very simple. It populates correctly and everything.

In a Server.find() i must retrieve the list of servers that got a specific owner. So the correct query would be something like

      FIND IN SERVER WHERE (OWNERS ARRAY) CONTAINS (THIS ID)

Which i translated in Mongoose as ...

      Server.find({'owners.$': user._id}).exec(function(error, servers) {

        console.log(servers);

      });

I was thinking "owners.$" let us search through a collection-array and in this case compare it with user._id but I was wrong, it seems the ".$" can only be used in a ".update()" query.

How can you do the same for a find ? What is the equivalent ? I'm searching everywhere and can't find out the solution ...

Thank you people ;)

JohnnyHK · Accepted Answer · 2014-05-03 16:18:29Z

1

You're making it more complicated than it needs to be as you can directly filter on array properties just as you would a normal property:

Server.find({owners: user._id}).exec(function(error, servers) {
    console.log(servers);
});

answered May 3, 2014 at 16:18

JohnnyHK

313k70 gold badges631 silver badges478 bronze badges

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

1 Comment

Laurent Over a year ago

How my god ! Thank you that was so simple I didn't even try ! :)

Collectives™ on Stack Overflow

Mongoose / Mongo find in array

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related