Unable to use $regex in mongoose in aggregation query?

Question

I am getting an error while using $regex in mongoose aggregation query . I am getting an invalid operator with error no 15999 . Please help guys.

{ $match: { "_id": ObjectId(req.headers.token) } }, {
                        $project: {
                            inventory: {
                                $filter: {
                                    input: '$inventory',
                                    as: 'inventory',
                                    cond: {$or:[{"$$inventory.item":new RegExp('^'+req.query.text+'$', "i")},{"$$inventory.sku":new RegExp('^'+req.query.text+'$', "i")}]}
                                }
                            },
                            _id: 0
             }
  }

If you can use JS code, try escaping it as req.query.text.replace(/[-\/\\^$*+?.()|[\]{}]/g, '\\$&'). If the text contains [ or ( or other special regex metacharacters, this should fix the issue. — Wiktor Stribiżew
– Wiktor Stribiżew, Commented Jul 10, 2016 at 11:17
Not sure if you can use regex in $project stackoverflow.com/questions/29866336/… — jpaljasma
– jpaljasma, Commented Jul 10, 2016 at 15:31

aaditya · Accepted Answer · 2018-02-15 06:32:32Z

1

You can use regex in $match and you will get your result as in this example

Pincodes.aggregate([
{ "$match": { "district": new RegExp('^' + req.query.district, "i") } 
},
{ "$group": { "_id": "$district" } }])
.exec((err, data) => {
if (err) {
res.status(500).json({
data: err
})
}
else {
res.status(200).json({
data: data
})
}
})

answered Feb 15, 2018 at 6:32

aaditya

7739 silver badges19 bronze badges

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

Comments

Derese Getachew · Accepted Answer · 2020-02-29 10:47:28Z

0

Doing just agg.match({'<fieldName'>:new RegExp('^' + req.query.district, "i")}) didnt work for me

I had to use eval in the solution. if you are JSON.stringifying the aggregate query to see the output you won't see the effect of eval. Eval will have an effect later on when passed down to mongo.

agg.match({'<fieldName'>:eval(new RegExp('^' + req.query.district, "i"))});

answered Feb 29, 2020 at 10:47

Derese Getachew

4607 silver badges10 bronze badges

Collectives™ on Stack Overflow

Unable to use $regex in mongoose in aggregation query?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related