[{"_id":{"$oid":"5f9041196462be3c5ca1e53d"},"codigoFinca":"000","nombreFinca":"PROVINCIANA","fechaRegistro":"2020-10-21","semanaRegistro":"43","usuarioRegistro":"cotorreo","trabajadoresFinca":[{"porcentajeRecargo":0,"_id":{"$oid":"5f9041196462be3c5ca1e53e"},"udpTrabajador":[{"unidadesAPagar":null,"valorUnidad":"","areaLaborada":"2","semanaNormal":null,"semanaAtrazos":null,"_id":{"$oid":"5f1041196462be3c5ca1e53e"},"detalleInsumos":[{"_id":{"$oid":"5f9041196462be3c5ca1e540"},"codigoInsumo":"20000001","descripcionInsumo":"NYLON X 5 KILOS","cantidadAplicada":"153","idRDI":"426715","idDetalleSaldo":"24070"},{"_id":{"$oid":"5f9041196462be3c5ca1e541"},"codigoInsumo":"20000001","descripcionInsumo":"NYLON X 5 KILOS","cantidadAplicada":"153","idRDI":"426715","idDetalleSaldo":"24070"}],"codigoLabor":"101","nombreLabor":"AMARRE","loteLaboro":"1"},{"unidadesAPagar":null,"valorUnidad":"","areaLaborada":"2","semanaNormal":null,"semanaAtrazos":null,"_id":{"$oid":"5f9041196462be3c5ca1e53f"},"detalleInsumos":[{"_id":{"$oid":"5f9041196462be3c5ca1e542"},"codigoInsumo":"20000001","descripcionInsumo":"NYLON X 5 KILOS","cantidadAplicada":"153","idRDI":"426715","idDetalleSaldo":"24070"},{"_id":{"$oid":"5f9041196462be3c5ca1e543"},"codigoInsumo":"20000001","descripcionInsumo":"NYLON X 5 KILOS","cantidadAplicada":"153","idRDI":"426715","idDetalleSaldo":"24070"}],"codigoLabor":"101","nombreLabor":"AMARRE","loteLaboro":"1"}],"codigoTrabajador":"0000","nombresTrabajador":"HUMBERTO MENA MOSQUERA","horasJornada":"10","horasLaboradas":"10"},{"porcentajeRecargo":0,"_id":{"$oid":"5f9041196462be3c5ca1e53f"},"udpTrabajador":[{"unidadesAPagar":null,"valorUnidad":"","areaLaborada":"2","semanaNormal":null,"semanaAtrazos":null,"_id":{"$oid":"5f9041296462be3c5ca1e53e"},"detalleInsumos":[{"_id":{"$oid":"5f9041196462be3c5ca1e544"},"codigoInsumo":"20000001","descripcionInsumo":"NYLON X 5 KILOS","cantidadAplicada":"153","idRDI":"426715","idDetalleSaldo":"24070"},{"_id":{"$oid":"5f9041196462be3c5ca1e545"},"codigoInsumo":"20000001","descripcionInsumo":"NYLON X 5 KILOS","cantidadAplicada":"153","idRDI":"426715","idDetalleSaldo":"24070"}],"codigoLabor":"101","nombreLabor":"AMARRE","loteLaboro":"1"},{"unidadesAPagar":null,"valorUnidad":"","areaLaborada":"2","semanaNormal":null,"semanaAtrazos":null,"_id":{"$oid":"5f9041196462be3c5ca1e53f"},"detalleInsumos":[{"_id":{"$oid":"5f9041196462be3c5ca1e546"},"codigoInsumo":"20000001","descripcionInsumo":"NYLON X 5 KILOS","cantidadAplicada":"153","idRDI":"426715","idDetalleSaldo":"24070"},{"_id":{"$oid":"5f9041196462be3c5ca1e547"},"codigoInsumo":"20000001","descripcionInsumo":"NYLON X 5 KILOS","cantidadAplicada":"153","idRDI":"426715","idDetalleSaldo":"24070"}],"codigoLabor":"101","nombreLabor":"AMARRE","loteLaboro":"1"}],"codigoTrabajador":"0000","nombresTrabajador":"HUMBERTO MENA MOSQUERA","horasJornada":"10","horasLaboradas":"10"}],"createdAt":{"$date":"2020-10-21T14:09:29.876Z"},"updatedAt":{"$date":"2020-10-21T15:09:51.657Z"},"__v":0}]

db.collection.aggregate([{$match:{"trabajadoresFinca.udpTrabajador.detalleInsumos._id":ObjectId("5f9041196462be3c5ca1e540")}},{$project:{detalleInsumos:{$reduce:{input:"$trabajadoresFinca",initialValue:{},in:{$mergeObjects:["$$value",{$reduce:{input:"$$this.udpTrabajador",initialValue:{},in:{$mergeObjects:["$$value",{$arrayElemAt:[{$filter:{input:"$$this.detalleInsumos",cond:{$eq:["$$this._id",ObjectId("5f9041196462be3c5ca1e540")]}}},0]}]}}}]}}}}}])