mongoose find object into array of object

Question

I'm new in mongoose and I'm trying to find user by code [user.test.test1.code] , any idea ?

Model :

const userSechema = new mongoose.Schema({     
name: {
    type: String,
    required: true
  },
     test: [{}],
 })

Data :

{
    "_id": {
        "$oid": "600020ab34742c2d34ae45e5"
     },
    "test": [{
       "test1": {
            "code": 11111
        },
       "test2": {
          "code": 22222
        }
      }]
   "name": "daniel"
}

query :

let regex = new RegExp(req.query.searchUserKey, 'i')
const users = await User.find({ $or: [{'name': regex },{'test.test1': { code : regex} }]})

-- Solution --

Thanks you guys, both answers is work for me

J.F. · Accepted Answer · 2021-01-14 14:35:29Z

1

Is as simple as do "test.test1.code": 418816 into find query like this:

db.collection.find({
  "test.test1.code": 418816
})

This query will give you all documents where exists test.test1.code with value 418816.

Note that this query return the whole document, not only the sub-document into the array. But I'm assuming by your post that a user is the document where exists the field name.

Example here

edited Jan 14, 2021 at 14:35

answered Jan 14, 2021 at 14:29

J.F.

15.3k10 gold badges41 silver badges74 bronze badges

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

Comments

Mohammad Yaser Ahmadi · Accepted Answer · 2021-01-14 14:28:22Z

0

you can use $elemMatch, check the documentation

const users = await User.find(
   { test: { $elemMatch: { "test1.code": 418816 } } }
)

answered Jan 14, 2021 at 14:28

Mohammad Yaser Ahmadi

5,0814 gold badges21 silver badges45 bronze badges

Collectives™ on Stack Overflow

mongoose find object into array of object

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related