0 Replies Latest reply on May 1, 2016 4:58 PM by cacodri

    Scheduler trigger fails when a parameter has several values

    cacodri

      Hello everyone,

       

      In my data model I have a data set:


      Select *

      from v_cobranza

      where        Convenio IN (:Convenio)

                 and Docto_Tipo IN (:Docto_Tipo)

                 and EstadoCobranza IN (:EstadoCobranza)

                 and email_1 is not null

       

      Scheduler Trigger:

       

      Select cobranza

      from v_cobranza

      where        Convenio IN (:Convenio)

                 and Docto_Tipo IN (:Docto_Tipo)

                 and EstadoCobranza IN (:EstadoCobranza)

                 and email_1 is not null

       

      when schedul a report without the trigger, the report work fine, when activate the trigger and the parameter are only one value each also work fine, but when at least one the paramater are several values, the report does not run.

       

      please someone has a solution that can help me

       

      Thank you very much

       

      Carlos