MongoDB slice query into golang

Question

How can i write this below slice query into golang?

db.con.find({"repoid":1356485},{"contr":{$slice:[0,10]}}).pretty()

Tried with this but not working

DB.C("con").Find(bson.M{"id": ID, "contr": bson.M{"$slice": []interface{}{"$contr", offset, limit}}})

does not find anything. Any ideas?

Thank you in advance

This question was asked twice yesterday (which questions were already deleted). Asking again and again is not the way to get attention and help. — icza
– icza, Commented May 30, 2019 at 10:37
Actually, i'm using this platform 1st time for asking question. sorry for my mistake. @icza — Chirag Painter
– Chirag Painter, Commented May 30, 2019 at 14:05

icza · Accepted Answer · 2019-05-30 13:05:59Z

2

With Collection.Find() you can only specify the filter. But what you have is a projection:

{"contr":{$slice:[0,10]}

Projections can be specified using Query.Select(), so this is how you can apply a $slice in projection:

var results []bson.M // Use your own type here, but this works too

err := DB.C("con").Find(bson.M{"id": ID}).Select(bson.M{
    "contr": bson.M{"$slice": []int{offset, limit}},
}).All(&results)

// handle error

Also note sure if the property you filter by is "id" or is just a typo and it should be "_id". If the latter, you may also use Collection.FindId() to query by document ID:

err := DB.C("con").FindId(ID).Select(bson.M{
    "contr": bson.M{"$slice": []int{offset, limit}},
}).All(&results)

edited May 30, 2019 at 13:05

answered May 30, 2019 at 12:51

icza

423k78 gold badges1k silver badges905 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MongoDB slice query into golang

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related