spotfirespotfire-webplayer

Information Link parameters to be displayed on Text area in spotfire


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' 

Solution

  • 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