首页 > 解决方案 > mongoDb 聚合值作为键和值

问题描述

我的数据如下所示:

{ "display" : [{
        "SQL commands that triggered the attack:" : ""
      }, {
        "Timetsamp" : "Query:"
      }, [[{
            "ISODate" : "2021-03-14T17:14:58.064Z"
          }, "EXECUTE IMMEDIATE"], [{
            "ISODate" : "2021-03-14T17:14:58.064Z"
          }, "EXECUTE IMMEDIATE"], [{
            "ISODate" : "2021-03-14T17:14:58.064Z"
          }, "EXECUTE IMMEDIATE"]]]
  }

我怎样才能让它看起来像这样:

"display" : [
{ "SQL commands" : ""}, 
{"Timetsamp" : "Query:"},
{"2021-03-14T17:14:58.064Z" : "EXECUTE IMMEDIATE"},
{"2021-03-14T17:14:58.064Z" : "EXECUTE IMMEDIATE"},
{"2021-03-14T17:14:58.064Z" : "EXECUTE IMMEDIATE"}]
}

在文档的一个字段中与其他字段一起显示

标签: mongodbaggregation-framework

解决方案


推荐阅读