Mongoose query find 'string' in object field in array of objects

Question

My model looks like this:

Collection = new Schema({
 name: {type: String, required: true},
 tags: [String],
 movies: [{_id: false,
          original_title: {type: String}}]
)};

I need to alter the following query to use 'req.body' (an array of strings) to not only find a match in the 'tags' array but also find match(es) with the 'original_title' field in the movies array.

Collection.find({'tags' : { $in : req.body}}, (err, collections) => {           
            if(err){res.status(400).json(err);}

            if(!collections)
            {
                res.status(404).json({message: 'No collections found'});
            }else{
                res.json(collections);
            }
        }).limit(8);

Omri Luzon · Accepted Answer · 2017-04-12 17:40:02Z

3

Try this:

db.collection.find({
    $or: [{
            'tags': {
                $in: req.body
            }
        },
        {
            'original_title': {
                $in: req.body
            }
        }
    ]
}, (err, collections) => {
    if (err) {
        res.status(400).json(err);
    }

    if (!collections) {
        res.status(404).json({
            message: 'No collections found'
        });
    } else {
        res.json(collections);
    }
}).limit(8);

answered Apr 12, 2017 at 17:40

Omri Luzon

4,2826 gold badges22 silver badges29 bronze badges

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

2 Comments

JakePlatford Over a year ago

This works, but I'm having problems with case sensitivity. Any idea how to ignore that for the 'original_title' condition?

Omri Luzon Over a year ago

I know it can be done for a single string using regex, not sure about an array. But I still think it's better for you to store and search your values when they are all consistently lower or upper cased.

Collectives™ on Stack Overflow

Mongoose query find 'string' in object field in array of objects

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related