How to use $in operator with an array containing multiple or single value

Question

Im trying to create a mongoose query using the $in operator which specifically requires an array as the input.

I pass in an array of search.interests, however depending on the user input the interests array could be either 1 value or many. If it is many it works fine, if its a single value then the $in operator fails.

"$in needs an array"

As i don't know how many interests my user will choose, how do i ensure search.interests is an array even with one value, so i can carry on using $in operator for both use cases.

search(req, res) {

    let search = req.query;

    console.log(search.interests);

    User.where('profile.interests').in(search.interests)
        .select('_id')
        .exec((err, users) => {

            if (err) {
                return res.json(err);
            }

            return res.json(users);

        });

}

Indent · Accepted Answer · 2017-11-28 12:36:21Z

1

Force to array type : http://rextester.com/JFXO55055

interests_array = [].concat(search.interests || [])

in your code :

User.where('profile.interests').in([].concat(search.interests || []))
    .select('_id')
    .exec((err, users) => {

        if (err) {
            return res.json(err);
        }

        return res.json(users);

    });

edited Nov 28, 2017 at 12:36

answered Nov 28, 2017 at 12:29

Indent

5,0171 gold badge22 silver badges39 bronze badges

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

Collectives™ on Stack Overflow

How to use $in operator with an array containing multiple or single value

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