Database

[{"id":"ID1","status":"ST1","logs":[{"id":"ID2","status_old":"ST2","status_new":"ST3",},{"id":"ID3","status_old":"ST3","status_new":"ST4",}]},{"id":"ID4","status":"ST4","logs":[{"id":"ID5","status_old":"ST2","status_new":"ST3",}]}]

Query

db.collection.aggregate([{"$match":{"$or":[{"status":"ST1"},{"logs.status_old":"ST1"},{"logs.status_new":"ST1"}]}},{"$match":{"$or":[{"status":"ST2"},{"logs.status_old":"ST2"},{"logs.status_new":"ST2"}]}}])

Result