|
As error says you, expressions are not supported for column view parameter: Can't use column expression as column view parameter. However, there are options to calculate it: If your parameter's value is semantically related to this calculated view (e.g. you need some default value for this view that is calculated based on some logic), then you can create a stored procedure with one output parameter to calculate the value, and use parameter type Derived From Procedure/Scalar Function. To make that value adjustable from frontend you can mark it as Input enabled. Or if calculated value is based on user input, you can map input parameters of procedure to input parameters of calculation view in section Parameters/Variables -> Procedures/Scalar functions for input parameters. create procedure sp_dummy ( in dummy nvarchar(10) default '0', out val nvarchar(10) ) as begin val = to_char(current_date, 'yyyymmdd'); end;
To return a result set, use a SELECT statement because anonymous blocks do not have any parameters defined. do begin declare lv_param nvarchar(100); select max('some_date') into lv_param from dummy /*your_table*/; select * from "_SYS_BIC"."path.to.your.view/CV_TEST" ( PLACEHOLDER."$$P_DUMMY$$" => :lv_param ); end;That with calculation view based on the table RSPCLOGCHAIN filtered by output of the procedure declared above gives me LOG_ID | DATUM | INPUT_PARAM | CUR_DATE --------------------------+----------+-------------+---------- 8FRV39X1O8814X6IJMLPI47PV | 20201221 | some_date | 20201221 C7S9EY3J0GYA76Y2S9CIA39QR | 20201221 | some_date | 20201221 35R8A3RFUG00EBY8MZQWJLIXF | 20201221 | some_date | 20201221 850MVHOJIKIDD7EVY6WFIYPZN | 20201221 | some_date | 20201221 (责任编辑：) |
