database - mongo 查询 - 从对象数组中获取特定对象（它的 `_id` 是已知的）但是这个数组也是文档列表的一部分

Question

鉴于我有它的_id--> 即消息 ID，我如何查询以从收件箱或发件箱中获取特定消息。

this is my route 
get("/getSpecificMessage/{Message_id}", (req, res) => {..}

我能做的是找到所有买家/经销商，然后通过所有买家/经销商的收件箱/发件箱，然后找到带有_idie message_id 的消息-> 我能做得更好吗？

{
        "_id" : ObjectId("5b8f0f4de276dd1e0ff083e1"),
        "address" : {
                "proper_address" : "sarai kale khan",
                "lat" : 28.58894,
                "long" : "77.25692"
        },
        "name" : "prashant",
        "password" : "jfalksdjlk;jasdl",
        "email" : "[e-mail]",
        "inbox" : [
                {
                        "_id" : ObjectId("5b8f0f4de276dd1e0ff083e4"),
                        "date" : ISODate("2018-09-04T23:03:41.627Z"),
                        "from" : "[e-mail]",
                        "message" : "message_1"
                },
                {
                        "_id" : ObjectId("5b8f0f4de276dd1e0ff083e3"),
                        "date" : ISODate("2018-09-04T23:03:41.627Z"),
                        "from" : "[e-mail]",
                        "message" : "message_2"
                },
                {
                        "_id" : ObjectId("5b8f0f4de276dd1e0ff083e2"),
                        "date" : ISODate("2018-09-04T23:03:41.627Z"),
                        "from" : "[e-mail]",
                        "message" : "message_3"
                }
        ],
        "outbox" : [
                {
                        "_id" : ObjectId("5b8f0f4de276dd1e0ff083e7"),
                        "date" : ISODate("2018-09-04T23:03:41.627Z"),
                        "to" : "[e-mail]",
                        "message" : "message_4"
                },
                {
                        "_id" : ObjectId("5b8f0f4de276dd1e0ff083e6"),
                        "date" : ISODate("2018-09-04T23:03:41.627Z"),
                        "to" : "[e-mail]",
                        "message" : "message_5"
                },
                {
                        "_id" : ObjectId("5b8f0f4de276dd1e0ff083e5"),
                        "date" : ISODate("2018-09-04T23:03:41.627Z"),
                        "to" : "[e-mail]",
                        "message" : "message_6"
                }
        ],
        "__v" : 0
}
{
        "_id" : ObjectId("5b8f0f4de276dd1e0ff083e8"),
        "address" : {
                "proper_address" : "najafgarah",
                "lat" : 28.58894,
                "long" : "77.25692"
        },
        "name" : "rahul",
        "password" : "jkalsjdflasdl",
        "email" : "[e-mail]",
        "inbox" : [
                {
                        "_id" : ObjectId("5b8f0f4de276dd1e0ff083eb"),
                        "date" : ISODate("2018-09-04T23:03:41.639Z"),
                        "from" : "[e-mail]",
                        "message" : "message_1"
                },
                {
                        "_id" : ObjectId("5b8f0f4de276dd1e0ff083ea"),
                        "date" : ISODate("2018-09-04T23:03:41.639Z"),
                        "from" : "[e-mail]",
                        "message" : "message_2"
                },
                {
                        "_id" : ObjectId("5b8f0f4de276dd1e0ff083e9"),
                        "date" : ISODate("2018-09-04T23:03:41.639Z"),
                        "from" : "[e-mail]",
                        "message" : "message_3"
                }
        ],
        "outbox" : [
                {
                        "_id" : ObjectId("5b8f0f4de276dd1e0ff083ee"),
                        "date" : ISODate("2018-09-04T23:03:41.639Z"),
                        "to" : "[e-mail]",
                        "message" : "message_4"
                },
                {
                        "_id" : ObjectId("5b8f0f4de276dd1e0ff083ed"),
                        "date" : ISODate("2018-09-04T23:03:41.639Z"),
                        "to" : "[e-mail]",
                        "message" : "message_5"
                },
                {
                        "_id" : ObjectId("5b8f0f4de276dd1e0ff083ec"),
                        "date" : ISODate("2018-09-04T23:03:41.639Z"),
                        "to" : "[e-mail]",
                        "message" : "message_6"
                }
        ],
        "__v" : 0
}

所以如果我有_id = 5b8f0f4de276dd1e0ff083ea并且我想要

{
  "_id" : ObjectId("5b8f0f4de276dd1e0ff083ea"),
  "date" : ISODate("2018-09-04T23:03:41.639Z"),
  "from" : "[e-mail]",
  "message" : "message_2"
}

标签： databasemongodb

Answer 1

我不确定您是否希望使用 MongoDB 脚本或您的应用程序语言（如果我弄错了 Nodejs）

这就是它在 Mongo Shell 脚本上的工作方式

db.MODEL.find( { _id: DOCUMENT_ID },
                     { inbox: { $elemMatch: { _id: MESSAGE_ID } } } )

文档在这里

如果这不是您想要的，请更新您的帖子并添加您使用的语言/框架