$regex with $concat in Query in MongoDB

Question

I am trying to search for users based on their names. My user schema looks like:

user: {
  firstName: string,
  lastName: string,
  ...
}

I can run the following query fine:

const userDocs = await UserModel
  .find({
    $expr: {
      $eq: [
        {
          $concat: [
            '$firstName',
            ' ',
            '$lastName',
          ],
        },
        'John Doe',
      ],
    },
  });

However I am trying to run a query such as this:

const userDocs = await UserModel
  .find({
    $expr: {
      $regex: [
        {
          $concat: [
            '$firstName',
            ' ',
            '$lastName',
          ],
        },
        new RegExp(`^${text}`, 'i'),
      ],
    },
  });

However MongoDB does not support this.

Is there a way to use $regex with a $concat?

s7vr · Accepted Answer · 2018-03-04 07:47:04Z

10

Aggression expression don't support regex expression query expression do.

Try aggregate

Create a extra field name in the aggregation pipeline combining first name and last name followed by match with regular expression.

const userDocs = await UserModel.aggregate
({$addFields:{
   name:{
    $concat:[
     '$firstName',
     ' ',
     '$lastName',
    ]
  }
}},
{$match:{
   name:new RegExp(`^${text}`, 'i')
}});

edited Mar 4, 2018 at 7:47

answered Mar 4, 2018 at 7:42

s7vr

76.2k12 gold badges118 silver badges135 bronze badges

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

Comments

nurariefhs · Accepted Answer · 2021-10-28 02:40:18Z

2

You can also try $regexMatch to query without aggregate like this

const userDocs = await UserModel
  .find({
    $expr: {
        $regexMatch: {
            input: {
                $concat: ['$firstName', ' ', '$lastName']
            }
            regex: /^${text}/
            options: 'i'
        }
    }
  });

answered Oct 28, 2021 at 2:40

nurariefhs

192 bronze badges

Collectives™ on Stack Overflow

$regex with $concat in Query in MongoDB

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related