How can I filter arrays in mongodb using mongoose?

Question

I have created database with two collections. Each of these collections connected with relations. Here I want to pass one item _id and check whether it passed to other collection as foreign key. If it's passed, I want to filter all items which consist as _id. How can I do that. Here my mongoose query and screenshot of db. Thank you

route.get("/:id",(req,res)=>{
Vehicles.find({
    categories: [req.params.id]
}, (err, data)=>{
    if(err){
        console.log(err);
    }else{
        console.log(data);
    }
});

MongoDB Screenshot

PS: For an example I want to get all vehicles which have category id "60c58c2dcf82de0780051378" inside categories array.

MongoDB - category collection

@hhharsha36 I updated question with new ss. can you check it please? — racketman
– racketman, Commented Jun 13, 2021 at 5:41
Please share sample input in JSON instead of screenshot and expected output. Its difficult to interpret by screenshot reference. — hhharsha36
– hhharsha36, Commented Jun 13, 2021 at 6:13

hoangdv · Accepted Answer · 2021-06-13 06:38:59Z

1

Following the mongo document, you can query for all documents where categories is an array that contains the objectId req.params.id as one of its elements.

Vehicles.find({
  categories: req.params.id,
}, (err, data) => {
  if (err) {
    console.log(err);
  } else {
    console.log(data);
  }
});

answered Jun 13, 2021 at 6:38

hoangdv

16.3k4 gold badges31 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

How can I filter arrays in mongodb using mongoose?

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