mongodb - 我想根据 Mongo DB 中的匹配条件（ID）将集合（发布）中的几个字段添加到另一个集合（故事）中

Question

集合：故事（这是主要集合，需要附加发布集合中的 2 个字段。）

{
    "_id" : ObjectId("5d131d93e2838c3b753e6631"),
    "expand" : "schema,names",
    "total" : 2,
    "issues" : [ 
        {
            "expand" : "operations,versionedRepresentations,editmeta,changelog,renderedFields",
            "id" : "131",
            "fields" : {
                "updateddate" : "2019-06-12T10:58:12.345+0530",

                "fixVersions" : [ 
                    {
                        "id" : "10008",
                        "description" : "New Release 2",
                        "name" : "New Release 2"
                    }, 
                    {
                        "id" : "10009",
                        "description" : "New Release 3",
                        "name" : "New Release 3"
                    }
                ],
                "aggregatetimespent" : null
            }
        },
        {
            "expand" : "operations,versionedRepresentations,editmeta,changelog,renderedFields",
            "id" : "10032",
            "fields" : {
                "updateddate" : "2019-06-22T10:58:12.345+0530",

                "fixVersions" : [ 
                    {
                        "id" : "10008",
                        "description" : "New Release 2",
                        "name" : "New Release 2"
                    }
                ],
                "aggregatetimespent" : null
            }
        }       

    ]
}

集合：发布（这是另一个集合，其中字段很少）

{
    "_id" : ObjectId("5d131a35e2838c3b753e6626"),
    "id" : "10008",
    "startDate" : "2019-06-28",
    "releaseDate" : "2019-07-05"
}
{
    "_id" : ObjectId("5d131a35e2838c3b753e6626"),
    "id" : "10009",
    "startDate" : "2019-08-28",
    "releaseDate" : "2019-09-05"
}

需要根据条件将开始日期和发布日期附加到数组字段中。预期输出：

收藏：故事

{
    "_id" : ObjectId("5d131d93e2838c3b753e6631"),
    "expand" : "schema,names",
    "total" : 2,
    "issues" : [ 
        {
            "expand" : "operations,versionedRepresentations,editmeta,changelog,renderedFields",
            "id" : "131",
            "fields" : {
                "updateddate" : "2019-06-12T10:58:12.345+0530",

                "fixVersions" : [ 
                    {
                        "id" : "10008",
                        "description" : "New Release 2",
                        "name" : "New Release 2",   
                        "startDate" : "2019-06-28",
                        "releaseDate" : "2019-07-05"
                    }, 
                    {
                        "id" : "10009",
                        "description" : "New Release 3",
                        "name" : "New Release 3",    
                        "startDate" : "2019-08-28",
                        "releaseDate" : "2019-09-05"
                    }
                ],
                "aggregatetimespent" : null
            }
        },
        {
            "expand" : "operations,versionedRepresentations,editmeta,changelog,renderedFields",
            "id" : "10032",
            "fields" : {
                "updateddate" : "2019-06-22T10:58:12.345+0530",

                "fixVersions" : [ 
                    {
                        "id" : "10008",
                        "description" : "New Release 2",
                        "name" : "New Release 2", 
                        "startDate" : "2019-06-28",
                        "releaseDate" : "2019-07-05"
                    }
                ],
                "aggregatetimespent" : null
            }
        }       

    ]
}

标签： mongodbmongodb-query