Mongoose query array of objects by _id

Question

I have the following Schema:

const userSchema = new Schema({
  local: {
    email: {type: String, unique: true, lowercase: true, trim: true, required: true},
    password: {type: String, required: true},
  },
  Items: [{
    name: {type: String, trim: true},
    createdAt: {type: Date, default: Date.now, select: false}
  }]
});

How do I query 'Items' (which contains array of objects) based on a specific _id that I will receive from the url parameter?

I have many different variations, including one shown below, but they all seem to return the Items array containing all objects, instead of just a single object matching the id?

User.findById(req.user.id, {}, {"Items._id": req.params.id}, (err, result) => { ... }

Use projection. Something like User.findOne({_id:req.user.id, "Items._id": req.params.id},{}, {"Items.$": 1}, (err, result) => { ... } — s7vr
– s7vr, Commented Mar 22, 2017 at 23:00
May be I have the incorrect mongoose query. You can verify it running it in mongo shell. db.users.findOne({_id:req.user.id, "Items._id": req.params.id},{"Items.$": 1}). It will return one item value. I'll try to find the right mongoose query. — s7vr
– s7vr, Commented Mar 23, 2017 at 0:35
Yeah it does work in the mongo shell, should i use it in mongoose? or is there more efficient way to write it? Thanks — linasmnew
– linasmnew, Commented Mar 23, 2017 at 0:45
Np. Yeah if you know how to convert to mongoose. I believe this is the right query in mongoose. User.findOne({_id:req.user.id, "Items._id": req.params.id},{"Items.$": 1}, (err, result) => { ... } — s7vr
– s7vr, Commented Mar 23, 2017 at 0:48

s7vr · Accepted Answer · 2017-03-23 13:18:12Z

2

You will have to use $projection to access element from embedded array. The query part finds the matching array element and replaces the placeholder $ with the array index of the matching element and projection part with $ will now use the placeholder value to project the array element as a response.

Mongo Shell Variant : db.users.findOne({_id:req.user.id, "Items._id": req.params.id},{"Items.$": 1})

Mongoose Variant: User.findOne({_id:req.user.id, "Items._id": req.params.id},{"Items.$": 1}, (err, result) => { ... }

answered Mar 23, 2017 at 13:18

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

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

6 Comments

s7vr Over a year ago

Can you show me your query ? Mixing of exclusion and inclusion paths are not allowed in projection with the exception of _id field.

linasmnew Over a year ago

It's the same as what you provided, just the second object contains "_id":0 in front of "Items.$":1 which works fine, but how would I modify this overall query to get rid of the createdAt property from the result? I suppose I can call lean() on findOne to turn it into a regular object and then use delete user.Items[0].createdAt, but any way of doing it on the database side?

s7vr Over a year ago

Nope, you can't like I said. You can't have both inclusion("Items.$": 1) and exclusion path ("Items.createdAt": 0) in the same projection. You have to take care of that on the mongoose side. More here docs.mongodb.com/v3.2/tutorial/…

linasmnew Over a year ago

Sorry I'm new to mongo and mongooose, would calling lean() on findOne and using delete user.Items[0].createdAt be an efficient way to solve this problem? Or is there a more efficient way to accomplish this?

s7vr Over a year ago

I'm no expert in mongoose but looks like lean is what you need if you are concerned with performance which I personally think is not a issue here at all. This gives more info about lean stackoverflow.com/questions/7503450/… & stackoverflow.com/questions/15097375/… . I hope this calms you a little bit.

|

AJ Funk · Accepted Answer · 2017-03-22 23:01:05Z

0

What you're trying to do is query for a subdocument. Check out http://mongoosejs.com/docs/subdocs.html

You can do something like:

User.findById(req.user.id, (err, user) => {
 let item = user.Items.id(req.params.id);
});

answered Mar 22, 2017 at 23:01

AJ Funk

3,1971 gold badge18 silver badges18 bronze badges

5 Comments

linasmnew Over a year ago

I'm looking for a way to do it on the database side, rather then app level

linasmnew Over a year ago

And I'm not using a subdocument, I have a single schema, 'Items' is just a name, just like 'local'

AJ Funk Over a year ago

@linasmnew Yes, those are subdocuments - that's why they have _id. Unless you specify that you do not want an ID, it will be there. All objects in Mongo are documents.

linasmnew Over a year ago

Thanks didn't know that, what does the 'id' in user.Items.id refer to? because when i query the database inside the terminal there's only _id

AJ Funk Over a year ago

DocumentArrays have a special id method for looking up a document by its _id. mongoosejs.com/docs/subdocs.html

Collectives™ on Stack Overflow

Mongoose query array of objects by _id

2 Answers 2

6 Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related