API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Mar 27th, 2017
55
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Apache Log 103.35 KB | None | 0 0
raw download clone embed print report
  1. 2017-03-27 18:38:32.350 DEBUG [adn360-cuentas,48017244df1ef520,48017244df1ef520,false] 6832 --- [nio-8080-exec-1] o.s.data.mongodb.core.MongoTemplate      : Executing aggregation: { "aggregate" : "contratos" , "pipeline" : [ { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "301"}} , { "$match" : { "subproducto" : { "$in" : [ "001" , "008" , "513" , "523" , "549"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}}]}
  2. 2017-03-27 18:38:32.451  INFO [adn360-cuentas,48017244df1ef520,48017244df1ef520,false] 6832 --- [nio-8080-exec-1] org.mongodb.driver.connection            : Opened connection [connectionId{localValue:2, serverValue:191644}] to oclmongc002.isbcloud.isban.corp:27017
  3. 2017-03-27 18:38:32.650 DEBUG [adn360-cuentas,48017244df1ef520,48017244df1ef520,false] 6832 --- [nio-8080-exec-1] o.s.data.mongodb.core.MongoTemplate      : Executing aggregation: { "aggregate" : "contratos" , "pipeline" : [ { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "301"}} , { "$match" : { "subproducto" : { "$in" : [ "001" , "008" , "513" , "523" , "549"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "301"}} , { "$match" : { "subproducto" : { "$in" : [ "145" , "502" , "516" , "529"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}}]}
  4. 2017-03-27 18:38:32.752 DEBUG [adn360-cuentas,48017244df1ef520,48017244df1ef520,false] 6832 --- [nio-8080-exec-1] o.s.data.mongodb.core.MongoTemplate      : Executing aggregation: { "aggregate" : "contratos" , "pipeline" : [ { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "301"}} , { "$match" : { "subproducto" : { "$in" : [ "001" , "008" , "513" , "523" , "549"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "301"}} , { "$match" : { "subproducto" : { "$in" : [ "145" , "502" , "516" , "529"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "300"}} , { "$match" : { "subproducto" : { "$in" : [ "149" , "172"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}}]}
  5. 2017-03-27 18:38:32.858 DEBUG [adn360-cuentas,48017244df1ef520,48017244df1ef520,false] 6832 --- [nio-8080-exec-1] o.s.data.mongodb.core.MongoTemplate      : Executing aggregation: { "aggregate" : "contratos" , "pipeline" : [ { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "301"}} , { "$match" : { "subproducto" : { "$in" : [ "001" , "008" , "513" , "523" , "549"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "301"}} , { "$match" : { "subproducto" : { "$in" : [ "145" , "502" , "516" , "529"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "300"}} , { "$match" : { "subproducto" : { "$in" : [ "149" , "172"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "300"}} , { "$match" : { "subproducto" : { "$in" : [ "313" , "315" , "316" , "325"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}}]}
  6. 2017-03-27 18:38:32.954 DEBUG [adn360-cuentas,48017244df1ef520,48017244df1ef520,false] 6832 --- [nio-8080-exec-1] o.s.data.mongodb.core.MongoTemplate      : Executing aggregation: { "aggregate" : "contratos" , "pipeline" : [ { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "301"}} , { "$match" : { "subproducto" : { "$in" : [ "001" , "008" , "513" , "523" , "549"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "301"}} , { "$match" : { "subproducto" : { "$in" : [ "145" , "502" , "516" , "529"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "300"}} , { "$match" : { "subproducto" : { "$in" : [ "149" , "172"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "300"}} , { "$match" : { "subproducto" : { "$in" : [ "313" , "315" , "316" , "325"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "300"}} , { "$match" : { "subproducto" : { "$in" : [ "001" , "145" , "007" , "506" , "525" , "017"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}}]}
  7. 2017-03-27 18:38:33.066 DEBUG [adn360-cuentas,48017244df1ef520,48017244df1ef520,false] 6832 --- [nio-8080-exec-1] o.s.data.mongodb.core.MongoTemplate      : Executing aggregation: { "aggregate" : "contratos" , "pipeline" : [ { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "301"}} , { "$match" : { "subproducto" : { "$in" : [ "001" , "008" , "513" , "523" , "549"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "301"}} , { "$match" : { "subproducto" : { "$in" : [ "145" , "502" , "516" , "529"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "300"}} , { "$match" : { "subproducto" : { "$in" : [ "149" , "172"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "300"}} , { "$match" : { "subproducto" : { "$in" : [ "313" , "315" , "316" , "325"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "300"}} , { "$match" : { "subproducto" : { "$in" : [ "001" , "145" , "007" , "506" , "525" , "017"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "100"}} , { "$match" : { "subproducto" : { "$in" : [ "001" , "102"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}}]}
  8. 2017-03-27 18:38:33.190 DEBUG [adn360-cuentas,48017244df1ef520,48017244df1ef520,false] 6832 --- [nio-8080-exec-1] o.s.data.mongodb.core.MongoTemplate      : Executing aggregation: { "aggregate" : "contratos" , "pipeline" : [ { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "301"}} , { "$match" : { "subproducto" : { "$in" : [ "001" , "008" , "513" , "523" , "549"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "301"}} , { "$match" : { "subproducto" : { "$in" : [ "145" , "502" , "516" , "529"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "300"}} , { "$match" : { "subproducto" : { "$in" : [ "149" , "172"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "300"}} , { "$match" : { "subproducto" : { "$in" : [ "313" , "315" , "316" , "325"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "300"}} , { "$match" : { "subproducto" : { "$in" : [ "001" , "145" , "007" , "506" , "525" , "017"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "100"}} , { "$match" : { "subproducto" : { "$in" : [ "001" , "102"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "100"}} , { "$match" : { "subproducto" : { "$in" : [ "003" , "024"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}}]}
  9. 2017-03-27 18:38:33.311 DEBUG [adn360-cuentas,48017244df1ef520,48017244df1ef520,false] 6832 --- [nio-8080-exec-1] o.s.data.mongodb.core.MongoTemplate      : Executing aggregation: { "aggregate" : "contratos" , "pipeline" : [ { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "301"}} , { "$match" : { "subproducto" : { "$in" : [ "001" , "008" , "513" , "523" , "549"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "301"}} , { "$match" : { "subproducto" : { "$in" : [ "145" , "502" , "516" , "529"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "300"}} , { "$match" : { "subproducto" : { "$in" : [ "149" , "172"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "300"}} , { "$match" : { "subproducto" : { "$in" : [ "313" , "315" , "316" , "325"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "300"}} , { "$match" : { "subproducto" : { "$in" : [ "001" , "145" , "007" , "506" , "525" , "017"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "100"}} , { "$match" : { "subproducto" : { "$in" : [ "001" , "102"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "100"}} , { "$match" : { "subproducto" : { "$in" : [ "003" , "024"]}}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}} , { "$match" : { "interv.idCliente" : "F000030219" , "$or" : [ { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "01" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "08" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "09" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "12" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "13" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "14" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "15" , "formaInterv" : { "$in" : [ "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "16" , "formaInterv" : { "$in" : [ "01" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "17" , "formaInterv" : { "$in" : [ "01" , "02"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "21" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "24" , "formaInterv" : { "$in" : [ "00" , "01" , "02" , "03"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "25" , "formaInterv" : "01" , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "47" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "48" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}} , { "interv" : { "$elemMatch" : { "idCliente" : "F000030219" , "tipoInterv" : "49" , "formaInterv" : { "$in" : [ "01" , "02" , "03" , "04" , "05" , "06" , "07"]} , "fechaBaja" : "9999-12-31"}}}]}} , { "$match" : { "producto" : "100"}} , { "$match" : { "subproducto" : "100"}} , { "$sort" : { "idContrato" : -1}} , { "$lookup" : { "from" : "saldos" , "localField" : "idContrato" , "foreignField" : "idContrato" , "as" : "saldos"}}]}
  10. 2017-03-27 18:38:33.408  INFO [adn360-cuentas,48017244df1ef520,48017244df1ef520,false] 6832 --- [nio-8080-exec-1] c.i.p.a.accounts.logger.Adn360Logger     : ***** Completed: public com.isb.poc.adn360.accounts.model.AccountO com.isb.poc.adn360.accounts.web.AccountsRestController.getListAccountWithFieldsHierarchies(java.lang.String,java.lang.String,java.lang.String) *****
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!