Skip to Content
1
Former Member
Sep 04, 2014 at 04:43 AM

Passing Set of values to Calculation View on SQL Procedure

12 Views

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