Skip to content
Related Articles
Get the best out of our app
GeeksforGeeks App
Open App
geeksforgeeks
Browser
Continue

Related Articles

How does Query.prototype.collation() work in Mongoose?

Improve Article
Save Article
Like Article
Improve Article
Save Article
Like Article

The Query.prototype.collation() allows users to specify language-specific rules for various comparison like string comparison such as rules for accent marks or rules for letter case, etc.
Syntax: 
 

Query.prototype.collation()

Parameters: This function has one array parameter i.e. an object which can have various properties like locale, caseLevel, caseFirst, etc.
Return Value: This function returns Query Object.

Installing mongoose : 

npm install mongoose

After installing the mongoose module, you can check your mongoose version in command prompt using the command. 

npm mongoose --version

After that, you can just create a folder and add a file for example, index.js as shown below.

Example 1:

index.js




const mongoose = require('mongoose');
  
// Database connection
    useNewUrlParser: true,
    useCreateIndex: true,
    useUnifiedTopology: true
});
  
// User model
const User = mongoose.model('User', { 
    name: { type: String },
    age: { type: Number }
});
  
var query = User.find();
query.collation({ caseFirst:"upper" })
  
console.log("Collation set to : ", query.options)

The project structure will look like this: 
 

Run index.js file using below command: 

node index.js

Output:

Collation set to :  { collation: { caseFirst: 'upper' } }

Example 2:

index.js




const express = require('express');
const mongoose = require('mongoose');
const app = express()
  
// Database connection
    useNewUrlParser: true,
    useCreateIndex: true,
    useUnifiedTopology: true
});
  
// User model
const User = mongoose.model('User', { 
    name: { type: String },
    age: { type: Number }
});
  
var query = User.find();
query.collation({ caseFirst:"upper" })
  
console.log("Collation : ", query.options)
  
app.listen(3000, function(error ){
    if(error) console.log(error)
    console.log("Server listening on PORT 3000")
})

The project structure will look like this:

Run index.js file using below command: 

node index.js

Output: 

Server listening on PORT 3000
Collation :  { collation: { caseFirst: 'upper' } }

Reference:https://mongoosejs.com/docs/api/query.html#query_Query-collation


My Personal Notes arrow_drop_up
Last Updated : 12 Mar, 2021
Like Article
Save Article
Similar Reads
Related Tutorials