在mongodb中通过给定数组名称从嵌套数组中获取整个数组

Question

假设这是我的收藏

db.collection.insert([
    {
        "5496":[
            {
                "Asset Name":"HiScanSQ",
                "Chiller Temperature (deg)":"2",
                "Trays Used (nos)":"12",
                "Power (volts)":"123",
                "Pressure (psi)":"15",
                "Usage (hours)":"140",
                "Volume (ml)":"150",
                "Viscosity":"1.8",
                "Cartridge Revolution (rpm)":"1000"
            }
        ]
    },
    {
        "4963":[
            {
                "Asset Name":"Genome Analyzer",
                "Chiller Temperature (deg)":"451",
                "Trays Used (nos)":"3",
                "Power (volts)":"82",
                "Pressure (psi)":"55",
                "Usage (hours)":"280",
                "Volume (ml)":"1000",
                "Viscosity":"1.2",
                "Cartridge Revolution (rpm)":"976"
            }
        ]
    }
]);

如何获取整个数组?假设整个值为"5496“。我需要获取与特定资产相关的所有值。因此，如果我提供资产id，mongo应该返回所有资产详细信息。

Answer 1

试试这个：

db.collection.find( {}, { fields: { "5496": 1 }, function( err ,result ) {
    ...
});

Answer 2

db.collection.find( { "5496": { $exists: true } }, { "5496": 1, _id: 0 } ).pretty()
{
        "5496" : [
                {
                        "Asset Name" : "HiScanSQ",
                        "Chiller Temperature (deg)" : "2",
                        "Trays Used (nos)" : "12",
                        "Power (volts)" : "123",
                        "Pressure (psi)" : "15",
                        "Usage (hours)" : "140",
                        "Volume (ml)" : "150",
                        "Viscosity" : "1.8",
                        "Cartridge Revolution (rpm)" : "1000"
                }
        ]
}