英文:
How to use structure a bson query with query,where and in using go
问题
我想根据时间范围和在$in中使用的字段来获取文档条目。我可以很容易地使用mongoose和nodejs来实现，如下所示，其中param是键，params是一个数组：
Data.find({timestamp: {$gte: new Date(query.startDate),$lt: new Date(query.endDate)}}).where(`${param}`).in(params);
以下是我使用go和bson的尝试，我发现很难构建查询：
aliases := []string{"000", "111"}query := bson.M{"datetime": bson.M{"$gt": startDate,"$lt": endDate,},"$where": bson.M{"device_alias": bson.M{"$in": aliases}},}
请问有人可以帮助我解决这个问题吗？
英文:
I would like to get document entries based on time range and a field that is used in $in. I can do it very easily using mongoose and nodejs like so where param is the key and params is an array
Data.find({timestamp:{$gte: new Date(query.startDate),$lt: new Date(query.endDate)}}).where(`${param}`).in(params);
Below is my attempt with bson using go and bson. I am finding it diffucult on how to structure the query
aliases := []string {"000","111"}query := bson.M{"datetime": bson.M{"$gt": startDate,"$lt": endDate,},"$where":bson.M{"device_alias":bson.M{"$in": aliases}}}
Kindly could someone help me figure this out
答案1
得分: 0
你的尝试不是一个有效的MongoDB查询。请尝试使用以下代码替代：
query := bson.M{"datetime": bson.M{"$gt": startDate,"$lt": endDate,},"device_alias": bson.M{"$in": aliases},}
英文:
Your attempt is not a valid mongodb query. Try this instead:
query := bson.M{"datetime": bson.M{"$gt": startDate,"$lt": endDate,},"device_alias":bson.M{"$in": aliases},}
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论