Dark Mode
Image

Node.js MongoDB Filter Query

The find() method is also used to filter the result on a specific parameter. You can filter the result by using a query object.

Example

Filter the records to retrieve the specific employee whose address is "Delhi".

Create a js file named "query1.js", having the following code:

PlayNext

Unmute

Current Time 0:00

/

Duration 18:10

Loaded: 0.37%

 

Fullscreen

Backward Skip 10sPlay VideoForward Skip 10s

  1. var http = require('http');  
  2. var MongoClient = require('mongodb').MongoClient;  
  3. var url = "mongodb://localhost:27017/MongoDatabase";  
  4. MongoClient.connect(url, function(err, db) {  
  5. if (err) throw err;  
  6. var query = { address: "Delhi" };  
  7. db.collection("employees").find(query).toArray(function(err, result) {  
  8. if (err) throw err;  
  9. console.log(result);  
  10. db.close();  
  11. });  
  12. });  

Open the command terminal and run the following command:

  1. Node query1.js  

Node.js Filter query 1


Node.js MongoDB Filter With Regular Expression

You can also use regular expression to find exactly what you want to search. Regular expressions can be used only to query strings.

Example

Retrieve the record from the collection where address start with letter "L".

Create a js file named "query2", having the following code:

  1. var http = require('http');  
  2. var MongoClient = require('mongodb').MongoClient;  
  3. var url = "mongodb://localhost:27017/MongoDatabase";  
  4. MongoClient.connect(url, function(err, db) {  
  5. if (err) throw err;  
  6. var query = { address: /^L/ };  
  7. db.collection("employees").find(query).toArray(function(err, result) {  
  8. if (err) throw err;  
  9. console.log(result);  
  10. db.close();  
  11. });  
  12. });  

Open the command terminal and run the following command:

  1. Node query2.js  

Node.js Filter query 2

Comment / Reply From