Find multiple objects based on array of values

Question

Given a model User with the field username is there a way to select all users with a username in an array? I could use a for loop like so to iterate through all the usernames:

var usernamesToFind = ["username", "anotherUsername", "etc"];
for (i = 0; i < usernameToFind.length; i++) {
    User.find({ "username": usernamesToFind[i] }, function(err, foundUser) {
        //notify user they got tagged
    });
}

Is it possible to achieve the result of above loop with one query, where instead of getting username by username, I do one query and get a list of users whose username matched any of the given usernames?

Andrew Li · Accepted Answer · 2018-01-07 21:05:25Z

1

You can use the $in operator to query, which:

[...] selects the documents where the value of a field equals any value in the specified array.

User.find({ username: { $in: usernamesToFind } }, function(err, foundUser) {
  //...
});

answered Jan 7, 2018 at 21:05

Andrew Li

58.1k14 gold badges135 silver badges150 bronze badges

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

Collectives™ on Stack Overflow

Find multiple objects based on array of values

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