Get object at the root level mongodb

Question

document:

{"_id":"5cb0dfe234a8a30c9c0af127",
"sensors":
[{"value0":0.153,
"value1":-0.306,
"value2":9.807}],
"timestamp":1555095522489,"__v":0}

I want to get 4 field (timestamp and value 0..2) without any array / object. unwind work only against array but not objects. What should I do?

desired output :

{timestamp":1555095522489,
value0":0.153,
value1":-0.306,
value2":9.807}

all documents from collection in format : timestamp, value0, value1, value2 {1555095522489, 0.153, -0.306, 9.807} — Dmitry Sokolov, Apr 14 '19 at 17:06
Please show the output in JSON format by editing your question — Ashh, Apr 14 '19 at 17:11
Possible duplicate of https://stackoverflow.com/questions/11189243/unwind-an-object-in-aggregation-framework — krishna Prasad, Apr 14 '19 at 17:49

Ashh · Accepted Answer · 2019-04-14T18:19:48.360

4

Use $unwind and $replaceRoot aggregation operators

db.collection.aggregate([   
  { "$unwind": "$sensors" },
  { "$replaceRoot": { "newRoot": { "$mergeObjects": ["$sensors", { "timestamp": "$timestamp" }] }}} 
])

edited Apr 14 '19 at 18:19

answered Apr 14 '19 at 18:11

Ashh

44,693
14
105
132

Get object at the root level mongodb

1 Answers1