How to filter fields from a mongo document with the official mongo-go-driver

by

Edit: As the mongo-go driver evolved, it is possible to specify a projection using a simple bson.M like this:

options.FindOne().SetProjection(bson.M{"_id": 0})

Original (old) answer follows.

The reason why it doesn’t work for you is because the field fields._id is unexported, and as such, no other package can access it (only the declaring package).

You must use a field name that is exported (starts with an uppercase latter), e.g. ID, and use struct tags to map it to the MongoDB _id field like this:

type fields struct {
    ID int `bson:"_id"`
}

And now to perform a query using a projection:

projection := fields{
    ID: 0,
}
result := staCon.collection.FindOne(
    nil, filter, options.FindOne().SetProjection(projection)).Decode(s)

Note that you may also use a bson.Document as the projection, you don’t need your own struct type. E.g. the following does the same:

projection := bson.NewDocument(
    bson.EC.Int32("_id", 0),
)
result := staCon.collection.FindOne(
    nil, filter, options.FindOne().SetProjection(projection)).Decode(s)

More Related Contents:

  1. How to ignore nulls while unmarshalling a MongoDB document?
  2. Retrieve only the queried element in an object array in MongoDB collection
  3. How to select a single field for all documents in a MongoDB collection?
  4. Best practice to maintain a mgo session
  5. mgo – query performance seems consistently slow (500-650ms)
  6. Efficient paging in MongoDB using mgo
  7. Random record from MongoDB
  8. Add new field to every document in a MongoDB collection
  9. Check that Field Exists with MongoDB
  10. Get a count of total documents with MongoDB when using limit
  11. ‘Failed to unlink socket file” error in MongoDB 3.0
  12. How to set and get fields in struct’s method
  13. Mongo order by length of array
  14. MongoDB group by array inner-elements
  15. Delete everything in a MongoDB database
  16. Mongodb Aggregation Framework: Does $group use index?
  17. How to return array of string with mongodb aggregation
  18. How to return just the nested documents of an array from all documents
  19. Mongoose’s find method with $or condition does not work properly
  20. How does MongoDB deal with concurrent updates?
  21. MongoDB print distance between two points
  22. Struct in for loop initializer
  23. querying a collection without passing schema in mongoose
  24. How to connect to external MongoDB instance in Meteor?
  25. Find documents whose array field contains at least n elements of a given array
  26. Generating a Structure for Aggregation
  27. Limiting results in MongoDB but still getting the full count?
  28. Mongodb : $in operator vs lot of single queries
  29. $project in $lookup mongodb
  30. Create filter aggregation in spring

Leave a Comment