mongoose findOne not working with array search query

Question

i have a document that store array of strings , i want search by id and by array contain. i used 2 method , both of them return null

the Schema example:

const exampleSchema = new mongoose.Schema{
id : objectId(),
list :Array // will store other id's
}
const Example= mongoose.model("Example", exampleSchema );

// this work
const friend = await Example.findOne({ _id: req.body.friendId }); // return the docuemnt

//this not work - return null
const friend = await Example.findOne({ _id: req.body.friendId, pending: { $in: [req.body.userId] } });

also i tried $elemMatch that not work

Dipten · Accepted Answer · 2022-07-13 09:45:28Z

1

As per the schema you mentioned it has 2 fields, _id and list. So your query need to modify as below.

const friend = await Example.findOne({ _id: req.body.friendId, list: { $in: [req.body.userId] } });

answered Jul 13, 2022 at 9:45

Dipten

1,08211 silver badges19 bronze badges

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

1 Comment

Bennyh961 Over a year ago

now i try to understand how to hapdate that list. i post the question here , see if u can help please stackoverflow.com/questions/72957889/…

Collectives™ on Stack Overflow

mongoose findOne not working with array search query

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related