how to find data in nested array in mongodb and node js

Viewed 18

i am trying to find corder data in below documents but i can not do this work if you know about how to find nested array data in below document so please find data for {corder}.

 {
  "_id": "63064232cf92b07e37090e0a",
  "sname": "Bombay collection ",
  "phone": 9963366555,

  "costomer": [
   {
     "cname": "Ammar ",
     "cphone": 919628497,
     "ccity": "Palanpur",
     "_id": "632ef012a9b88eb59d0210fa",
      "corder": [
          {
              "clothType": "Pathani", 
               "prize": 236,
               "date": "2022-09-24",
               "status": "true",
               "_id": "632ef078a9b88eb59d02110c"
          }
        ],

      }
    ],
  },

and my code is id = "main document id" & obid ="cosomer id " & orid = " order id "

app.get('/getuser/:id/:obid/:orid', async (req, res) => {
  try {
    const id = req.params.id
    const obid = req.params.obid
    const orid = req.params.orid
    console.log(id);
    const peruserdata = await getschema.find({ 'costomer.corder': orid }  , 
    { "_id": orid, "costomer.$.corder": { $elemMatch: { "_id": orid } }   });
    res.status(201).json(peruserdata);
 } catch (error) {
    console.log(error);
    res.send(error)
 }
})



  
0 Answers
Related