Node.js MongoDB Find with projection to exclude _id still returns it

Question

Trying to follow the examples here to filter by using a projection to exclude _id. The _id still returns:

Code

var MongoClient = require('mongodb').MongoClient; var url = "mongodb://localhost:27017/db1";  MongoClient.connect(url, function (err, db) {     if (err) throw err;     var dbase = db.db("db1"); //here          dbase.collection("customers").find(         {},         {             _id: 0          }         ).toArray(function(err, result) {         if (err) throw err;         console.log(result);         db.close();     });  }); 

Result still return as follows:

[ { _id: 5a2bb2d6ee48575cb54c4365, name: 'John', address: 'Highway 71' }, { _id: 5a2bb2d6ee48575cb54c436d, name: 'Susan', address: 'One way 98' }, .... { _id: 5a2bb2d6ee48575cb54c4371, name: 'Chuck', address: 'Main Road 989' }, { _id: 5a2bb2d6ee48575cb54c4372, name: 'Viola', address: 'Sideway 1633' } ]

Theoretically _id should not be part of what is returned. What is wrong here?

Answer 1

To limit the fields you have to use fields option( dont know about new updates):

dbase.collection("customers").find({}, {     fields: { _id: 0 } }).toArray(function(err, result) {     if (err) throw err;     console.log(result);     db.close(); }); 

UPDATE:

For version > 3 you have to use projection option instead:

dbase.collection("customers").find({}, {     projection:{ _id: 0 } }).toArray(function(err, result) {     if (err) throw err;     console.log(result);     db.close(); });