[{"_id":ObjectId("616bcd746bfed71fdcf892c3"),"boards":[{"_id":ObjectId("6175f8c69c03810ea8e7b31e"),"color":"","labels":[{"color":"blue","title":"project1"}],"lists":[{"_id":ObjectId("6175f8c69c03810ea8e7b321"),"archived":true,"cards":[]},{"_id":ObjectId("6175f8c69c03810ea8e7b322"),"archived":false,"cards":[]},{"_id":ObjectId("6175f8c69c03810ea8e7b323"),"archived":false,"cards":[{"archived":true,"attachments":[],"comments":[],"description":"","labelSelected":[],"title":"mycard"}]},{"_id":ObjectId("6175f8c69c03810ea8e7b324"),"archived":false,"cards":[{"archived":false,"attachments":[],"comments":[],"description":"","labelSelected":[],"title":"mycard"}]}],"name":"myboard"}],"description":"","name":"myworkspace","userId":ObjectId("611cb3a14f142d5d94daa395")}]

db.collection.aggregate([{"$unwind":{"path":"$boards"}},{"$replaceRoot":{"newRoot":"$boards"}},{"$set":{"lists":{"$filter":{"input":"$lists","cond":{"$and":[{"$eq":["$$this.archived",false]},{"$or":[{"$eq":["$$this.cards",[]]},{"$in":[false,"$$this.cards.archived"]}]}]}}}}}])