Passing Set of values to Calculation View on SQL Procedure
We have a scenario where we need to pass the set of values at a time.
current SQL statement
( "$$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.