How to make case insensitive query in mongodb

Question

this API is getting called for per change. it can be a number or name field. here the task is I want to search name with case-insensitively.

 router.get('/v1/branch/search/customers/:phoneNumber',authenticate , (req, res) => {
    var regex = "/^"+req.params.phoneNumber+"/", name ="/^"+req.params.phoneNumber+"$/i"; 

    Customer.find({
        subscriberId: req.user.subscriberId,$or:[{$where:regex+'.test(this.phoneNumber)'},{$where:name+'.test(this.name)'},{$where:regex+'.test(this.name)'}],
        _creator : req.user._id
      },{name:1,phoneNumber:1,_id:0}).sort({name: 1}).then((customer) => {
        res.send({'statusCode':0,'data':customer});
      }, (e) => {
        console.log(e);
        res.status(200).send({'statusCode':2,'message':e.message});
      }); 
  });

Above code is working case-insensitively only for some names not for all data. I am not getting what wrong I am doing here.

Possible duplicate of stackoverflow.com/questions/1863399/… — Jabongg
– Jabongg, Commented Feb 20, 2019 at 5:20

Vivek Ghanchi · Accepted Answer · 2019-02-20 05:17:33Z

2

you can use regex queries

{ "name" : { $regex: /Ghost/, $options: 'i' }

including this to your code will solve the problem of case-insensitively.

answered Feb 20, 2019 at 5:17

Vivek Ghanchi

2324 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

How to make case insensitive query in mongodb

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related