1 Reply Latest reply: Dec 5, 2013 2:23 AM by 970365 RSS

    Convert this filter to SQL

    970365

      Hi

      I have 2 prompt ID and BIC

      both i set Presentation variable.I passed this values into my report filter.In report filter i set "Covert this filter to SQL" option.

      But when i choose values into my both Prompt then i can able to see values in my report.But when i choose single prompt value then not able to display.

      Please check my filter. When i set directly Credit_Bic like '%%' then working fine but when i put case condition then not display any records?


      and"Case Header"."Credit Id" LIKE (CASE WHEN '3582020570001'='' THEN '%%' ELSE '3582020570001' END)
      and"Case Header"."Credit Bic" LIKE (CASE WHEN ''='' THEN '%%' ELSE '@{ClientBIC}' END)

       

       

      Thanks

      Gram

        • 1. Re: Convert this filter to SQL
          970365

          Solved.

          and"Case Header"."Credit Id" LIKE (CASE WHEN '3582020570001' IS NULL THEN '%%' ELSE '3582020570001' END)
          and

          "Case Header"."Credit Bic" LIKE (CASE WHEN '' IS NULL THEN '%%' ELSE '@{ClientBIC}' END)

           

          I set IS NULL instead of =