I have an IL with 2 parameter ?Mindate & ?Maxdate , those parameters i want to display on the header's text area. How to add them? As they are not the part of any tables or IL's. I am passing these parameters through webplayer's ConfigBlock. My IL query is as below:
SELECT F1."PROTOCOL_ID" ,
F1."PROTOCOL_TYPE" ,
F1."PROJECT_CODE" ,
F1."PROTOCOL_STATUS"
count(distinct case when not M2."ECG_REJECTED_PROTOCOL" is null
and M2."ECG_REJECTED_PROTOCOL_DT"<=?Maxdate
and M2."ECG_REJECTED_PROTOCOL_DT" <=?Mindate
and (M2."ECG_REJECTED_PROTOCOL_DT">=M2."ECG_DISPATCH_PROTOCOL_DT" or M2."ECG_REJECTED_PROTOCOL_DT">=M2."ECG_STORED_PROTOCOL_DT") then M2."ES_ECG_ID" end) AS "D30C6"
FROM
"BIECGRPT"."FINANCE_REPORT_STUDIES" F1,
"BIECGRPT"."MV_FINANCE_RPT_MAIN" M2
WHERE
(M2."ECG_REJECTED_PROTOCOL" = F1."PROTOCOL_ID")
AND F1."PROTOCOL_ID" <> '223HV102_RV'
A configuration block parameter is automatically assigned to a document property, if a document property with the same name and data type is defined in the analysis.
https://community.tibco.com/wiki/create-configuration-block-tibco-spotfire