• 请不要在回答技术问题时复制粘贴 AI 生成的内容
crimeshaper
V2EX  ›  程序员

go mongodb 查找问题,请教各位大佬啊

  •  
  •   crimeshaper · Jan 8, 2020 · 1120 views
    This topic created in 2327 days ago, the information mentioned may be changed or developed.

    数据结构如下,我想查找 Age 大于 800 的,但返回的总是 Hero 这个全集,各位大佬,这怎么写,我快疯了,难道要查出来再代码过滤一遍

    { "_id" : ObjectId("5e130585a10ebd71287d86a2"), "item" : "journal", "qty" : 25, "Hero" : [ { "Name" : "张三", "Age" : 819 }, { "Name" : "王兀", "Age" : 888 }, { "Name" : "刘备", "Age" : 9 }, { "Name" : "孙尚香", "Age" : 78 } ] } 查找代码如下:

    find := coll.FindOne( context.Background(), bson.M{ "Hero":bson.M{ "$elemMatch":bson.M{ "Age":bson.M{ "$gt":800, }, }, }, })

    var info bson.M e1 := find.Decode(&info)

    返回的是 Hero 全集,试过 coll.Aggregate(ctx,pipe),效果也一样啊

    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   1322 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 48ms · UTC 17:11 · PVG 01:11 · LAX 10:11 · JFK 13:11
    ♥ Do have faith in what you're doing.