doukuanghuan7582 2018-10-17 15:35
浏览 154

从MongoDB中的Document中检索深层嵌套的子文档(PHP)

I have a collection similar to this:

{
'_id': ObjectId("5bc74908f2377d746g1e9983"),
components:{
    0: {
        index: 21,
        abc:22,
        sim: [
            {s_index:23},
            {hyx:45}
        ]
    },
    1: {
        index: 21,
        abc:22,
        sim: [
            {s_index:23},
            {hyx:45}
        ]
    }
   }
}

I am trying to output:

{
    index: 21,
    abc:22,
         sim: [
             {s_index:23},
             {hyx:45}
        ]
}

But with the following query:

$Result = $templates -> findOne(
[
    '_id' => new \MongoDB\BSON\ObjectId("5bc74908f2377d746g1e9983")
],
['projection' => ['_id' => false, 'components.0' => true]]
);

I am getting the output as:

{
   components:{
    0: {
        index: 21,
        abc:22,
        sim: [
            {s_index:23},
            {hyx:45}
        ]
    }
    }
}

Is there any way to get the desired output? I am trying to retrieve just the value of component.0 but I am getting the complete path in the document.

sim is an array of objects. What if I just want to retrieve a particular object in sim not the path from components to sim. Can this be done?

  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 使用C#,asp.net读取Excel文件并保存到Oracle数据库
    • ¥15 C# datagridview 单元格显示进度及值
    • ¥15 thinkphp6配合social login单点登录问题
    • ¥15 HFSS 中的 H 场图与 MATLAB 中绘制的 B1 场 部分对应不上
    • ¥15 如何在scanpy上做差异基因和通路富集?
    • ¥20 关于#硬件工程#的问题,请各位专家解答!
    • ¥15 关于#matlab#的问题:期望的系统闭环传递函数为G(s)=wn^2/s^2+2¢wn+wn^2阻尼系数¢=0.707,使系统具有较小的超调量
    • ¥15 FLUENT如何实现在堆积颗粒的上表面加载高斯热源
    • ¥30 截图中的mathematics程序转换成matlab
    • ¥15 动力学代码报错,维度不匹配