[{"_id":"1234567","data groups":{"group1":[{"clientname":"client1","companyname":"company1","data":{"item one":{"item name":"items full name","bool1":false,"bool2":false,"infofield":"info value"}}},{"clientname":"client2","companyname":"company2","data":{"item one":{"item name":"items full name","bool1":false,"bool2":false,"infofield":"info value"}}}],"group2":[{"clientname":"client1","companyname":"company1","data":{"subgroup76":{"item name":"item name 1","bool1":false,"bool2":false,"infofield":"info value"},"subgroup77":{"item name":"item name 2","bool1":false,"bool2":false,"infofield":"info value"},"subgroup10":{"item name":"item name 3","bool1":false,"bool2":false,"infofield":"info value"},"subgroup8":{"item name":"item name 4","bool1":false,"bool2":false,"infofield":"info value"}}},{"clientname":"client2","companyname":"company2","data":{"subgroup6":{"item name":"item name 1","bool1":false,"bool2":false,"infofield":"info value"},"subgroup5":{"item name":"item name 2","bool1":false,"bool2":false,"infofield":"info value"},"subgroup8":{"item name":"item name 3","bool1":false,"bool2":false,"infofield":"info value"}}}]}},{"_id":"1234568","data groups":{"group1":[{"clientname":"client1","companyname":"company1","data":{"item one":{"item name":"items full name","bool1":false,"bool2":false,"infofield":"info value"}}},{"clientname":"client2","companyname":"company2","data":{"item one":{"item name":"items full name","bool1":false,"bool2":false,"infofield":"info value"}}}],"group2":[{"clientname":"client1","companyname":"company1","data":{"subgroup76":{"item name":"item name 1","bool1":false,"bool2":false,"infofield":"info value"},"subgroup77":{"item name":"item name 2","bool1":false,"bool2":false,"infofield":"info value"},"subgroup10":{"item name":"item name 3","bool1":false,"bool2":false,"infofield":"info value"},"subgroup8":{"item name":"item name 4","bool1":false,"bool2":false,"infofield":"info value"}}},{"clientname":"client2","companyname":"company2","data":{"subgroup6":{"item name":"item name 1","bool1":false,"bool2":false,"infofield":"info value"},"subgroup5":{"item name":"item name 2","bool1":false,"bool2":true,"infofield":"info value"},"subgroup8":{"item name":"item name 3","bool1":false,"bool2":false,"infofield":"info value"}}}]}}]

db.collection.aggregate([{"$match":{"$expr":{"$reduce":{"input":{"$objectToArray":"$data groups"},"initialValue":false,"in":{"$or":["$$value",{"$anyElementTrue":{"$map":{"input":"$$this.v","as":"v","in":{"$reduce":{"input":{"$objectToArray":"$$v.data"},"initialValue":false,"in":{"$or":["$$value","$$this.v.bool1","$$this.v.bool2"]}}}}}}]}}}}}])