如何使用官方的mongo-go-driver驱动程序过滤mongo文档中的字段

Question

How can I filter fields with the mongo-go-driver. Tried it with findopt.Projection but no success.

type fields struct {
    _id int16
}

s := bson.NewDocument()
filter := bson.NewDocument(bson.EC.ObjectID("_id", starterId))

var opts []findopt.One
opts = append(opts, findopt.Projection(fields{
    _id: 0,
}))

staCon.collection.FindOne(nil, filter, opts...).Decode(s)

In the end, I want to suppress the field "_id". But the documents didn't change.

Answer 1

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)