db={"machines":[{"_id":ObjectId("5c793a188021710636865c33"),"MachineName":"CER3A","NextJobs":["ST105862","OFT083520","OFT083365","ST105946"]}],"works":[{"_id":ObjectId("5c1b89d0b6e97d001816595e"),"Lote":"OFT083520","Flags":{"ShipsFinished":true,"PlanFinished":true,"Finished":true,"IdDefecto":false,"EstadoOF":4,"GCT":"GCT018929","PedidoVenta":"","STS":"",}},{"_id":ObjectId("5dcd78e2a2061070185400e2"),"Lote":"OFT083671","Flags":{"B2":1,"EstadoOF":4,"Finished":false,"GCT":"GCT024270","LaSI":0,"PedidoVenta":"P056048","SPO":"PO23579","STS":"ST105862","Inks":"true",}},{"_id":ObjectId("5dcd78e2a2061070185401f0"),"Lote":"OFT083672","Flags":{"B2":1,"EstadoOF":4,"Finished":false,"STS":"ST105862","ShipsFinished":false,"TipoOF":1,"EstatIQC":1,}}]}

db.machines.aggregate([{$lookup:{from:"works",let:{"nj":"$NextJobs"},pipeline:[{$match:{$expr:{$or:[{$in:["$Lote","$$nj"]},{$in:["$Flags.STS","$$nj"]}]}}}],as:"linkedWorks"}}])