cancel
Showing results for 
Search instead for 
Did you mean: 

Calculation view with input parameters

tiago_queiroga
Explorer
0 Kudos

Hello there.

I got a calculation with that expects 2 input parameters.

But now I have to created another calculation view that import this calculation view.

How can I pass these 2 parameters using sqlscript?

  My script so far

  cv1 = CE_CALC_VIEW("_SYS_BIC"."calc_1",["CR"],'"COMPANY"=''7000''');

I must pass 2 parameters in this  "_SYS_BIC"."calc_1" table

Accepted Solutions (1)

Accepted Solutions (1)

kostyah
Participant
0 Kudos

Hi Tiago,

as I am aware, you cannot pass input parameters to CE function.

You can try using regular SQL syntax:

SELECT "CR" FROM "_SYS_BIC"."calc_1"

WHERE "COMPANY" = 7000

(PLACEHOLDER."$$PARAM_1$$" => VALUE_1,

PLACEHOLDER."$$PARAM_2$$" => VALUE_2)

Answers (2)

Answers (2)

tiago_queiroga
Explorer
0 Kudos

Thanks everyone.

I update my script using SQL instead of CE functions.

former_member182302
Active Contributor
0 Kudos

Have a look at this thread:

Regards,

Krishna Tangudu