在mongodb中查询对象数组

Question

我是mongodb的初学者，我想从一个对象数组中找到不同的对象。

我的文件是这样的：

    "_class" : "com.fico.ifm.translation.domain",

    "_id" : ObjectId("53a2bccae4b0200bdf7e7bc2"),

    "screens" : [ 
        {
            "_id" : "systemParametersInvestigation",
            "dictionary" : [ 
                {
                    "locale" : "en-US",
                    "parameterizedValue" : "Edit close investigation configuration",
                    "key" : "CLOSE_INVESTIGATION_UPDATE_ALLOWED"
                }, 
                {
                    "locale" : "pt-BR",
                    "parameterizedValue" : "",
                    "key" : "CLOSE_INVESTIGATION_UPDATE_ALLOWED"
                }, 
                {
                    "locale" : "nl-NL",
                    "parameterizedValue" : "",
                    "key" : "CLOSE_INVESTIGATION_UPDATE_ALLOWED"
                }, 
                {
                    "locale" : "en-US",
                    "parameterizedValue" : "Close investigation update setting",
                    "key" : "CLOSE_INVESTIGATION_UPDATE_ALLOWED_DESCRIPTION"
                }, 
                {
                    "locale" : "pt-BR",
                    "parameterizedValue" : "",
                    "key" : "CLOSE_INVESTIGATION_UPDATE_ALLOWED_DESCRIPTION"
                }
]

}

 {
            "_id" : "adminRoles",

            "dictionary" : [ 
                {
                    "locale" : "en-US",
                    "parameterizedValue" : "Add all",
                    "key" : "ADD_ALL"
                }, 
                {
                    "locale" : "pt-BR",
                    "parameterizedValue" : "",
                    "key" : "ADD_ALL"
                }, 
                {
                    "locale" : "nl-NL",
                    "parameterizedValue" : "",
                    "key" : "ADD_ALL"
                }, 
                ]

我想在screensi.dictionary中找到不同的“关键”

Answer 1

db.yourcoll.aggregate([
{
    $unwind:"$screens"
},{
    $unwind:"$screens.dictionary"
},{    
    $group: {
        _id:"$_id",
        distinctKey:{$addToSet:"$screens.dictionary.key"}
    }
},{

    $project: {
        "_id" : 0,
        "distinctKey":1
    }

}  
])

结果：

{
    "result" : [ 
        {
            "distinctKey" : [ 
                "CLOSE_INVESTIGATION_UPDATE_ALLOWED_DESCRIPTION", 
                "CLOSE_INVESTIGATION_UPDATE_ALLOWED"
            ]
        }
    ],
    "ok" : 1
}