Mongodb select information to get from an object without knowing object key

Question

I have this documents at my DB

{
"_id":"606b583b2506eb000988a8fd",
"lastSync":"2021-04-13T00:10:02.984+00:00",
"Month":{
    "2020-12":{
      "a":10,
      "b":21
    },
    "2021-01":{
      "a":112,
      "b":34
    },
    "2021-03":{
      "a":35,
      "b":56
    },
    "2021-02":{
      "a":767,
      "b":56
    },
    "2021-04":{
     "a":78,
     "b":98
   }
}
}

How can I query something like db.collection.agreggate(query) and get as answer an array like:

[
"2020-12":{
"a":10},
"2021-01":{
"a":112},...]

Have already tried agregation methods with $project but just could not find the kind of object I wanted

Please include valid JSON for your starting BSON document (what you have shown above is not valid JSON). — Tim Biegeleisen, Apr 13 '21 at 01:35

score 1 · Accepted Answer · answered Apr 13 '21 at 02:31

Demo - https://mongoplayground.net/p/v5My6yjrIC0

db.collection.aggregate([
  {
    $replaceRoot: {
      "newRoot": {
        $arrayToObject: { // convert array to object
          $map: { // loop over each item in an array and returns an array
            "input": { $objectToArray: "$Month"}, // convert to array
            "as": "el",
            "in": { k: "$$el.k", v: { a: "$$el.v.a" } // shape the data
            }
          }
        }
      }
    }
  }
])

If you want everything inside Month check this demo - https://mongoplayground.net/p/lD0wPTc_W4Y

db.collection.aggregate([
  {
    $replaceRoot: {
      "newRoot": "$Month"
    }
  }
])

Mongodb select information to get from an object without knowing object key

1 Answers1