Database

[{"_id":{"$oid":"6169547919aa9900011c3995"},"TranscriptionID":"YQPTKEU8JP9844YQVT4WY4HNQP","Status":1,"Created":{"$date":{"$numberLong":"1633671595666"}},"Modified":{"$date":{"$numberLong":"1633671595666"}},"Tracks":{"A3-A4":{"Language":"en_US","Sentences":[{"SentenceID":"20e8e7f1efd24098be28b3cb5cdbf081","StartTime":0,"EndTime":0,"Speaker":"spk_0","Content":"we should be recording everybody. So yes, this meeting is being recorded, abc","IsApproved":false,"ModifiedContent":"we should be recording everybody. So yes, this meeting is being recorded,","Words":[{"StartTime":8.84,"EndTime":9.19,"Type":"pronunciation","Content":"we","VocabularyFilterMatch":false,"Confidence":1}]},{"SentenceID":"fc80abf17f0c42b1833857a1dfb07481","StartTime":0,"EndTime":0,"Speaker":"spk_0","Content":"now we actually have to be somewhat professional. Okay,","IsApproved":true,"ModifiedContent":null,"Words":[{"StartTime":16.74,"EndTime":16.97,"Type":"pronunciation","Content":"now","VocabularyFilterMatch":false,"Confidence":0.999}]},{"SentenceID":"25f4c1dd322941d4993c02a3270db5bb","StartTime":8.84,"EndTime":13.565,"Speaker":"spk_0","Content":"hahahaha A3-A4 Server","IsApproved":false,"ModifiedContent":"we should be recording everybody. So yes, this meeting is being recorded,","Words":[{"StartTime":0,"EndTime":0,"Type":"pronunciation","Content":"we","VocabularyFilterMatch":false,"Confidence":1}]}]},"A5-A6":{"Language":"en_US","Sentences":[{"SentenceID":"ff62bda2900e4121bbd221c3d294af7c","StartTime":8.84,"EndTime":13.565,"Speaker":"spk_0","Content":"we should be recording everybody. So yes, this meeting is being recorded,","IsApproved":false,"ModifiedContent":"we should be recording everybody. So yes, this meeting is being recorded,","Words":[{"StartTime":0,"EndTime":0,"Type":"pronunciation","Content":"we","VocabularyFilterMatch":false,"Confidence":1}]},{"SentenceID":"de7328fb670e47b5aa91f8b808cf3e18","StartTime":16.74,"EndTime":21.965,"Speaker":"spk_0","Content":"now we actually have to be somewhat professional. Okay, whatevs","IsApproved":true,"ModifiedContent":null,"Words":[{"StartTime":0,"EndTime":0,"Type":"pronunciation","Content":"now","VocabularyFilterMatch":false,"Confidence":0.999}]}]}}}]

Query

db.collection.aggregate([{"$set":{"Tracks":{"$objectToArray":"$Tracks"}}},{"$unwind":"$Tracks"},{"$unwind":"$Tracks.v.Sentences"},{"$set":{"trackId":"$Tracks.k","sentence":"$Tracks.v.Sentences"}},{"$unset":"Tracks"}])

Result