Skip to Content
avatar image
Former Member

Passing Set of values to Calculation View on SQL Procedure

Hi All,

We have a scenario where we need to pass the set of values at a time.

current SQL statement

SELECT  "V_DATE",

                                         SUM("ITEMS"),

                                         SUM("HOURS"),

                                         sum("COUNTERS")

                                         FROM "_SYS_BIC"."*********"

                                         ( "$$DATEFROM$$" => :VAR_DATE )

                                                  

                                         GROUP BY "V_DATE".

In above statement we can pass only one value at a time but that is not usefull for us.

we have used the above select statement with in a loop to pass all desired values but that is having performance issues.

Here based on DATEFROM we are doing one calculation in Calculation View hence we can't distrub that view ( it is for to get open items for a day)

Thanks in Advance.

Regards

Jagan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 24, 2016 at 06:24 AM

    Hi Jagan,

             this will work for you

    SELECT COMPANY_NAME

    FROM B

    (

       'PLACEHOLDER' = ('$$IP_CUSTOMER_NAME$$', 'Adam',),

       'PLACEHOLDER' = ('$$IP_CUSTOMER_NAME$$', 'Ian')

    );



    All the Best

    Nagababu Tubati

    Add comment
    10|10000 characters needed characters exceeded