Mongoose - Is it possible to modify key's value to match with where condition for find() query?

Question

I am very familiar with Oracle when suddenly i had to create a project with MongoDB database. I am using mongoose to connect to my MongoDB. My question is, is that possible to match find condition before doing a query? For example, i got this name : John in my MongoDB then i just need to do this by Oracle SQL.

SELECT * FROM MY_SCHEMA.WORKERS WORKER
WHERE UPPER(WORKER.NAME) = 'JOHN'

In mongoDB, all I know and can do is this.

var mongoose = require('mongoose');
mongoose.connect('localhost:27017/myDB');
workers.find(
  {
    "name": "JOHN"
  }
);

I have been searching for solution and can't find one. Is there any way to set name's value to upper case to match the result i needed?

Any help would be appreciated :)

EDIT : I found the solution to this problem by using RegExp() for mongoose. RegExp will make my mongoDB docs case-insensitive to match my query's parameter. More details in this answer. https://stackoverflow.com/a/9824712/7498283

score 1 · Accepted Answer · answered Apr 06 '17 at 05:35

1

You can use toUpperCase() of javascript, if you want to do find with uppercase letters. refer-doc.

Try the code below:

workers.find(
{
  "name": ("JOHN").toUpperCase()
});

Hope this will help.

answered Apr 06 '17 at 05:35

Shrabanee

2,706
1
18
30

It's the `value` inside my document that I need to upperCase, not the parameter send from my client-side. But, thankyou for your response. :D – Yongky Ali Apr 06 '17 at 08:33
Can you show us your db and what you want to get with your find query? – Shrabanee Apr 06 '17 at 09:10
1

https://pastebin.com/kfJp6pgQ for example, i need to get `John` by using `JOHN` as my filter. Thankyou :D – Yongky Ali Apr 06 '17 at 09:40
Please have a look into the answer of the [question](http://stackoverflow.com/questions/1863399/mongodb-is-it-possible-to-make-a-case-insensitive-query) – Shrabanee Apr 06 '17 at 09:46
You can also try using https://docs.mongodb.com/manual/reference/operator/query/text/#op._S_text – Shrabanee Apr 06 '17 at 09:47
Will it work on mongoose? It works perfectly if i `find()` John from mongo shell. :D – Yongky Ali Apr 06 '17 at 10:00
Try it and let us know. – Shrabanee Apr 06 '17 at 10:00
your answer works by using RegExp for mongoose. RegExp will make all of my data in mongoDB docs become case insensitive to my query's parameter. More details in this answer http://stackoverflow.com/a/9824712/7498283 – Yongky Ali Apr 07 '17 at 02:31
Glad it helped. – Shrabanee Apr 07 '17 at 02:48

score 0 · Answer 2 · answered Apr 06 '17 at 06:34

0

You can use $toUpper operator in mongodb.

    worker.aggregate([
           {$project: {"name":{$toUpper:"$name"}}},
           {$find:{"name":"JOHN"}}
    ]);

answered Apr 06 '17 at 06:34

Ayush Mittal

1
2

Sorry, but I am using mongoose to do database CRUD. I edited my post just to point out that. Do you have any solution using mongoose to operate in mongoDB? – Yongky Ali Apr 06 '17 at 08:39

Mongoose - Is it possible to modify key's value to match with where condition for find() query?

2 Answers2