Mongoose select specific fields from array elements

Question

Let's say I have this schema

{
jedi: [{
       name:String
       lightsaber_color:String
      ]}
}

I want to return all and only the names of them. I tried

Jedi.find({})
    .select('jedi.name')
    .exec(function (err, jedi) {
      if (err) {
        console.log("nothing found")
      }
}

It returns me nothing, while this code returns me everything.

Jedi.find({})
        .select('jedi')
        .exec(function (err, jedi) {
          if (err) {
            console.log("nothing found")
          }
    }

I see that jedi is an array so I think that .select('jedi.name') may not work for this reason.
What is the right syntax to do so?

Soni Pandey · Accepted Answer · 2016-01-07 08:37:36Z

1

You can try with this

Jedi.find({}, {'jedi.name':1}, function (err, jedi) {
      if (err) {
        console.log("nothing found")
      }
      else{
        console.log(jedi);
      }
}

answered Jan 7, 2016 at 8:37

Soni Pandey

5145 silver badges16 bronze badges

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

6 Comments

r4id4 Over a year ago

Could you explain this syntax {'jedi.name':1}

Soni Pandey Over a year ago

In find query first object for query, second object you can pass whatever fields you want to get in result, hope it will work for you.

r4id4 Over a year ago

I cannot have it working. Basically it returns me the whole structure, not just the names. What's the meaning of the 1 in that code?

Soni Pandey Over a year ago

1 mean i have to return that field

r4id4 Over a year ago

Is is possible the problem is that the field is being populated with .populate('jedi')? Obv the example above is just trivial.

|

Collectives™ on Stack Overflow

Mongoose select specific fields from array elements

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related