Determine if value exists in user's embedded document array

Question

I know the User's ID, and I want to know if they have a value in their groceryList that matches "name" = "foo". Here is my current query, but it is returning result even though the name doesn't exist, I'm assuming since one of the values exists. How do I make it only return result if both values are true?

User.findOne( {"_id": req.user._id},{"groceryList": {"$elemMatch": {"name": ingredients.name[i]}}}, function(err, result) {
        if(err) {
                console.log(err);
            }
            else if(result) {
                console.log(result);
            }
    })

User Schema:

var groceryListSchema = mongoose.Schema({
quantity: { type: Number, required: true },
measurement: { type: String, required: true },
name: { type: String, required: true }
});

var userSchema = new mongoose.Schema({
username: String,
password: String,
recipes: [
  {
    type: mongoose.Schema.Types.ObjectId,
    ref: 'Recipe'
  }
],
groceryList: {
type: [ groceryListSchema ]
}
});

Try User.findOne({_id: user_id, "groceryList.name": "foo"}). $elemMatch might be a bit overkill for this since you're only trying to match the one field. Additionally, findOne expects a single argument, so if you want to use the original query, be sure to merge the two objects into a single argument. — B. Fleming
– B. Fleming, Commented Dec 19, 2017 at 2:18

russpol · Accepted Answer · 2017-12-19 02:22:15Z

1

the second argument should be a part of your query.

User.findOne({"_id": req.user._id, "groceryList": {"$elemMatch": {"name": ingredients.name[i]}}})

and as pointed out above it would be simpler to write:

Users.findOne({"_id": req.user._id, "groceryList.name": ingredients.name[i] })

answered Dec 19, 2017 at 2:22

russpol

1162 silver badges6 bronze badges

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

Collectives™ on Stack Overflow

Determine if value exists in user's embedded document array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related