How does Query.prototype.gt() work in Mongoose?
Last Updated :
17 Mar, 2021
The Query.prototype.gt() function is used to specify a $gt query condition. It returns documents that are greater than the specified condition.
Syntax:
Query.prototype.gt()
Parameters: This function has one val parameter and an optional path parameter.
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.
Database: The sample database used here is shown below:
Project Structure: The project structure will look like this:
Example 1:
index.js
const mongoose = require('mongoose');
// Database connection
mongoose.connect('mongodb://127.0.0.1:27017/geeksforgeeks', {
useNewUrlParser: true,
useCreateIndex: true,
useUnifiedTopology: true
});
// User model
const User = mongoose.model('User', {
name: { type: String },
age: { type: Number }
});
var query = User.find()
query.where('age').gt(25).exec(function(err, res){
if(err) console.log(err.message)
else console.log(res)
});
Run index.js file using below command:
node index.js
Output:
[ { _id: 5ebd345f5d2d8a3534b2f391,
name: 'Manish', age: 34, __v: 0 } ]
Example 2:
index.js
const express = require('express');
const mongoose = require('mongoose');
const app = express()
// Database connection
mongoose.connect('mongodb://127.0.0.1:27017/geeksforgeeks', {
useNewUrlParser: true,
useCreateIndex: true,
useUnifiedTopology: true
});
// User model
const User = mongoose.model('User', {
name: { type: String },
age: { type: Number }
});
var query = User.find()
query.where('age').gt(10).exec(function(err, res){
if(err) console.log(err.message)
else console.log(res)
});
app.listen(3000, function(error ) {
if(error) console.log(error)
console.log("Server listening on PORT 3000")
});
Run index.js file using below command:
node index.js
Output:
Server listening on PORT 3000
[
{ _id: 5ebc3669a99bde77b2efb9ba,
name: 'Lalit', age: 25, __v: 0 },
{ _id: 5ebd345f5d2d8a3534b2f391,
name: 'Manish', age: 34, __v: 0 }
]
Reference:
https://mongoosejs.com/docs/api/query.html#query_Query-gt