Survey

Please help us improve by answering a few questions at our user survey.

Projections

By default, queries in MongoDB return all fields in matching documents. To limit the amount of data that MongoDB sends to applications, you can include a projection document in the query operation.

Projection Document

The projection document limits the fields to return for all matching documents. The projection document can specify the inclusion of fields or the exclusion of field and has the following form:

{ field1: <value>, field2: <value> ... }

<value> may be 0 (or false) to exclude the field, or 1 (or true) to include it. With the exception of the _id field, you may not have both inclusions and exclusions in the same projection document.

Examples

The following code example uses the restaurants sample dataset.

To return only the name, cuisine and _id fields for documents which match the query filter, explicitly include the name and cuisine fields in the projection document. The _id field is included automatically unless specifically excluded.

const MongoClient = require('mongodb').MongoClient;
const assert = require('assert');

// Connection URL
const url = 'mongodb://localhost:27017';

// Database Name
const dbName = 'myproject';

// Create a new MongoClient
const client = new MongoClient(url);

// Use connect method to connect to the Server
client.connect(function(err, client) {
  assert.equal(null, err);
  console.log("Connected correctly to server");

  const db = client.db(dbName);

  findDocuments(db, function() {
    client.close();
  });  
});


function findDocuments(db, callback) {
  // Get the documents collection
  const collection = db.collection( 'restaurants' );
  // Find some documents
  collection
    .find({ 'cuisine' : 'Brazilian' })
    .project({ 'name' : 1, 'cuisine' : 1 })
    .toArray(function(err, docs) {
      assert.equal(err, null);
      console.log("Found the following records");
      console.log(docs)
      callback(docs);
    });
}

To return name and cuisine but exclude all other fields, including _id, use the following projection document:

{ 'name' : 1, 'cuisine' : 1, '_id': 0 }

To return all fields except the address field, use the following:

{ 'address' : 0 }