Mongoose Query.prototype.gt() API
Last Updated :
20 Jan, 2023
The Mongoose Query API gt() method is used to scan all the documents in a collection and return those whose path values are greater than that passed in the method’s argument.
Syntax:
Query.prototype.gt( path, val )
Parameters: It accepts the following parameters as mentioned above and described below:
- path: It is a string that identifies the attribute name in the mongoose schema
- val: It is a number that determines the minimum value to compare all the documents
Return type: It returns a Query object as a response.
Creating node application And Installing Mongoose:
Step 1: Create a node application using the following command:
mkdir folder_name
cd folder_name
npm init -y
touch main.js
Step 2: After completing the Node.js application, Install the required module using the following command:
npm install mongoose
Example 1: In this example, we will use this method to return documents that have age greater than “30”
Filename: main.js
Javascript
const mongoose = require( 'mongoose' )
{
dbName: 'event_db' ,
useNewUrlParser: true ,
useUnifiedTopology: true
}, err => err ? console.log(err)
: console.log( 'Connected to database' ));
const personSchema = new mongoose.Schema({
name: {
type: String,
},
age: {
type: Number,
}
});
const personsArray = [
{
name: 'Luffy' ,
age: 20
},
{
name: 'Nami' ,
age: 20,
},
{
name: 'Zoro' ,
age: 35
}
]
const Person = mongoose.model( 'Person' , personSchema);
(async () => {
await Person.insertMany(personsArray)
const res = await Person.find().where( 'age' ).gt(30);
console.log({ res });
})()
|
Step to Run Application: Run the application using the following command from the root directory of the project:
node main.js
Output:
GUI Representation of the Database using MongoDB Compass:
Example 2: In this example, we will use this method to return documents that have age greater than “40”
Filename: main.js
Javascript
const mongoose = require( 'mongoose' )
{
dbName: 'event_db' ,
useNewUrlParser: true ,
useUnifiedTopology: true
}, err => err ? console.log(err)
: console.log( 'Connected to database' ));
const personSchema = new mongoose.Schema({
name: {
type: String,
},
age: {
type: Number,
}
});
const personsArray = [
{
name: 'Luffy' ,
age: 20
},
{
name: 'Nami' ,
age: 20,
},
{
name: 'Zoro' ,
age: 35
}
]
const Person = mongoose.model( 'Person' , personSchema);
(async () => {
await Person.insertMany(personsArray)
const res = await Person.find().gt( 'age' , 40)
console.log({ res });
})()
|
Step to Run Application: Run the application using the following command from the root directory of the project:
node main.js
Output:
GUI Representation of the Database using MongoDB Compass:
Reference: https://mongoosejs.com/docs/api/query.html#query_Query-gt
Share your thoughts in the comments
Please Login to comment...