Manage mapings for input parameters in script calculaion view in selection statement

[Former Member]

Hi, i have got a scenario

In graphical calculation view GCV_PRS, when date is passed to parameter V_DATE it will select data for 1 day. its working fine.

I'm selecting data from GCV_PRS in Sql script view here i have to pass date to same parameter V_DATE from GCV_PRS. If i pass (PLACEHOLDER'=('$$V_date$$', '20181021')) in this case its coming but its not working dynamically.

Here i have to map V_date to I_DATE

But when i tried manage parameters i couldn't, its not showing parameter V_DATE.

If it's a graphical view we will select manage input parameter n link with previous CV parameter but here i'm not getting that. Any workaround for this?

Note: It's testing SQL view, i can't use graphical view cos there nearly 380 lines code is there.

[former_member209702]

Hi,

When you want to pass input parameter value dynamically in a script based calculation view, you can use below syntax to map input parameters -

select * 
From <graphical view name>
(PLACEHOLDER."$$V_DATE$$" => :I_DATE)