How to select a single field for all documents in a MongoDB collection?

by

From the MongoDB docs:

A projection can explicitly include several fields. In the following operation, find() method returns all documents that match the query. In the result set, only the item and qty fields and, by default, the _id field return in the matching documents.

db.inventory.find( { type: 'food' }, { item: 1, qty: 1 } )

In this example from the folks at Mongo, the returned documents will contain only the fields of item, qty, and _id.

Thus, you should be able to issue a statement such as:

db.students.find({}, {roll:1, _id:0})

The above statement will select all documents in the students collection, and the returned document will return only the roll field (and exclude the _id).

If we don’t mention _id:0 the fields returned will be roll and _id. The ‘_id’ field is always displayed by default. So we need to explicitly mention _id:0 along with roll.

More Related Contents:

  1. Retrieve only the queried element in an object array in MongoDB collection
  2. How to copy a collection from one database to another in MongoDB
  3. Clone a collection in MongoDB
  4. How to filter fields from a mongo document with the official mongo-go-driver
  5. What’s Mongoose error Cast to ObjectId failed for value XXX at path “_id”?
  6. In mongoDb, how do you remove an array element by its index?
  7. How to replace substring in mongodb document
  8. How do you use Mongoose without defining a schema?
  9. MongoDB nested lookup with 3 levels
  10. MongoDB : Aggregation framework : Get last dated document per grouping ID
  11. MongoDB vs. Cassandra [closed]
  12. Rounding to 2 decimal places using MongoDB aggregation framework
  13. How to print out more than 20 items (documents) in MongoDB’s shell?
  14. MongoDB – Update or Insert object in array
  15. Why does direction of index matter in MongoDB?
  16. How can I update multiple documents in mongoose?
  17. Matching an array field which contains any combination of the provided array in MongoDB
  18. MongoDB lookup when foreign field is an array of objects
  19. Get the latest record from mongodb collection
  20. Collision probability of ObjectId vs UUID in a large distributed system
  21. Changing MongoDB data store directory
  22. Mongoose limit/offset and count query
  23. Read-only file system when attempting mkdir /data/db on Mac [closed]
  24. mongodb move documents from one collection to another collection
  25. How does the order of compound indexes matter in MongoDB performance-wise?
  26. Multiply field by value in Mongodb
  27. How does MongoDB order their docs in one collection? [duplicate]
  28. count array occurrences across all documents with mongo
  29. Creating custom Object ID in MongoDB
  30. How to create a Mongo Docker Image with default collections and data?

Leave a Comment