How to search for records by using a value in object array from mongoose?

user_10375433 0
Viewed 25

I want to search for records using the below-mentioned Field and code I have used, returning nothing. I'm sure I'm querying wrongly, and can anyone help me build the correct query code?

Field I wanted to serach

Code I have used:

const { id } = req.params;

const requests = await Request.find({
    itemsList: { item: id },
});

Return:

console.log(requests);

requests: []
mongoose mongodb-query node.js mongodb
2 Answers
const requests = await Request.find({
    "itemsList.item": id,
});

will return the entire array if there is a match.

Playground

And make sure your data on the query part is matching the type.

In the image, you have a string. Use ObjectId if it is ObjectId.

user_26941840

Please try this

const requests = await Request.find({
    itemsList: { $elemMatch: { item: mongoose.Types.ObjectId(id) }}},
});
user_38201890
Related