Find specific property in MongooseJS array of objects

Question

I have a MongoDB object with an array of objects inside it, structured as

{
    otherInfo: String,
    invited: [{
        code: String,
        email: String
    }],
    moreInfo: String
}

I'm trying to find a specific object in that array with a specific code, and then get the email associated with that code.
I have tried .find({ invited: { $all: [{ code: 1234567890 }]}}) but it didn't return anything. I have tried other variations on it none none of them seem to have worked

Community · Accepted Answer · 2020-06-20 09:12:55Z

1

You can use the $elemMatch to solve your query

The $elemMatch operator limits the contents of an field from the query results to contain only the first element matching the $elemMatch condition.

Try this

db.collection.find({ invited: { $elemMatch: { code: 1234567890 } } } )

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Feb 23, 2019 at 0:27

molamk

4,1161 gold badge15 silver badges22 bronze badges

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

Comments

Wicak · Accepted Answer · 2019-02-23 00:41:53Z

1

Try like this

app.get('/', async (req, res) => { //change with your endpoint code
 const findCode = await Models.find({}) //change name of your models
 const result = findCode.invited.filter(item => {
   item.code ==  '1234567890'
 })
 console.log(result);
})

Or try with this:

Models.find().elemMatch("invited", {"code":"1234567890"}).exec((err,result)=>{
    console.log(result);
}) //change your Models name

edited Feb 23, 2019 at 0:41

answered Feb 23, 2019 at 0:06

Wicak

4095 silver badges13 bronze badges

1 Comment

molamk Over a year ago

This makes the database return all its items. It's a working solution though

Collectives™ on Stack Overflow

Find specific property in MongooseJS array of objects

2 Answers 2

Try this

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Try this

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related