Call a Graphical Calc view with input Parameters from a Script Based Calc View

[Former Member]

Hi All.

I am trying to call a graphical calculation view with input parameters from a script based calculation view as below but getting syntax error:

SESSION_SAMPLE = SELECT SESSION_CREATE_DATE,SHA256,CA_MEASURE

                             FROM "_SYS_BIC"."WILDFIRE/CV_SESSION_SAMPLE"

                             WITH PARAMETERS  ('PLACEHOLDER' = ('$$IP_START_DATE$$',:START_DATE),

                                 'PLACEHOLDER' = ('$$IP_END_DATE$$',:END_DATE));

START_DATE  and END_DATE are input parameters of the script based calculation view.

Can anyone please help me with the correct syntax for accomplishing this?

Thanks,

Goutham

[former_member182302 · Accepted solution]

Have a look on this thread

Regards,

Krishna Tangudu

[Former Member]

Hi Goutham,

Can you try this one?

SESSION_SAMPLE = SELECT SESSION_CREATE_DATE,SHA256,CA_MEASURE

                             FROM "_SYS_BIC"."WILDFIRE/CV_SESSION_SAMPLE"

                             WITH PARAMETERS  (PLACEHOLDER.'$$IP_START_DATE$$' => :START_DATE,

                                 PLACEHOLDER.'$$IP_END_DATE$$' => :END_DATE);

--

Shreepad

[former_member184768]

Please check the document below, it has screenshots for achieving the similar syntax.

Ravi

[former_member42822]

Hi Gautham,

Can you check with single input parameter instead of two and let me know if it works fine.

Regards,

Vinoth

[former_member42822]

Hi,

This should work,

SESSION_SAMPLE = SELECT SESSION_CREATE_DATE,SHA256,CA_MEASURE

                             FROM "_SYS_BIC"."WILDFIRE/CV_SESSION_SAMPLE"

                               ('PLACEHOLDER' = ('$$IP_START_DATE$$','$$START_DATE$$'),

                                 'PLACEHOLDER' = ('$$IP_END_DATE$$','$$END_DATE$$'));

Regards,

Vinoth

[Former Member]

Hi Vinoth,

It didn't work.

Below is the snapshot of the calc view and error message I am getting.

Goutham

[former_member42822]

Hi Gautham,

One more option  what i would like you to try is the below option , here i have just changed the order of passing nothing else.

SESSION_SAMPLE = SELECT SESSION_CREATE_DATE,SHA256,CA_MEASURE

                             FROM "_SYS_BIC"."WILDFIRE/CV_SESSION_SAMPLE"

                               ('PLACEHOLDER' = ('$$IP_END_DATE$$','$$END_DATE$$'),

                              'PLACEHOLDER' = ('$$IP_START_DATE$$','$$START_DATE$$'))

Regards,

Vinoth