Database

[{"id":1,"tasks":[{"Id":"123456","status":"OPEN","assignee":"ABC"},{"Id":"8989","status":"OPEN","assignee":"ABC"},{"Id":"53434","status":"COMPLETED","assignee":"CDE"},{"Id":"78878","status":"COMPLETED","assignee":"EFG"}]}]

Query

db.collection.aggregate([])

Result