How to look for strings in array using regex with MongoDB.?

Question

I have several objects like this:

"status": "published",
"term_id": [
   "anime",
   "sci-fi",
   "etc"
],
"captionCert": "1",

I know that in order to look within a single field, I would create something like this:

if (keyword) {
  query.status = { $regex: keyword, $options: 'i' };
}

Where keyword comes from the front end and can be whatever the user types; then I proceed to look into the field status and then I just retrieve it by passing it into my model query:

Video.find(query)

Now hte problem is that I need to know how to exactly do this but inside the term_id array?

Any idea? Thanks.

UPDATE: I'm trying to implement it into this function:

exports.searchVideos = asyncHandler(async (req, res, next) => {
  const query = {};
  const { keyword } = req.query;

  if (keyword) {
    query.title = { $regex: keyword, $options: 'i' };
  } else {
    query.text = { $regex: keyword, $options: 'i' };
  }

  if (keyword) {
    query.term_id = { term_id: { $regex: keyword, $options: 'i' } };
  };

  const video = await Video.find(query).select(
    'title text thumbnail video_url term_id'
  );
  console.log(query);
  res.status(200).json({ success: true, data: video });
});

Kirasiris · Accepted Answer · 2020-07-29 16:54:14Z

1

Solution after finding out about $or operator. This solved my problems!:

exports.searchVideos = asyncHandler(async (req, res, next) => {
  let query = {};
  const { keyword } = req.query;

  query = {
    $or: [
      { title: { $regex: keyword, $options: 'i' } },
      { text: { $regex: keyword, $options: 'i' } },
      { term_id: { $regex: keyword, $options: 'i' }}
    ]
  };

  const video = await Video.find(query).select(
    'title text thumbnail video_url term_id'
  );

  res.status(200).json({ success: true, data: video });
});

answered Jul 29, 2020 at 16:54

Kirasiris

55111 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

How to look for strings in array using regex with MongoDB.?

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