Mongoose where value in array

Question

I have the below code to return all blogs where the blog author ID is equal to the ID of the first administrator (orgAdmin) in an array:

let officialBlogs = await Blog.find().where('author.id').equals(help.orgAdmins[0]);

But I can't work out how to adapt this code so I can return blogs where the author matches ANY of the administrators in the array (i.e. orgAdmin[0], orgAdmin[1], orgAdmin[2] etc. Can anyone please advise?

Does this answer your question? Mongoose get docs matching the array — Anveeg Sinha
– Anveeg Sinha, Commented Jun 9, 2022 at 7:29

Apoorva Chikara · Accepted Answer · 2022-06-09 07:19:32Z

2

You can use $in operator to get things based on passed ids like this:

const ids = [];
help.orgAdmins.forEach(id => ids.push(id));

let officialBlogs = await Blog.find({author.id: { $in: ids }});

answered Jun 9, 2022 at 7:19

Apoorva Chikara

8,8033 gold badges24 silver badges39 bronze badges

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

2 Comments

Anveeg Sinha Over a year ago

we can pass help.orgAdmins directly right? instead of 'ids'

Apoorva Chikara Over a year ago

Yes, you can do that too if they are always fixed or same numbers.

Collectives™ on Stack Overflow

Mongoose where value in array

1 Answer 1

2 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related