如何在Spotfire文本区域显示WebPlayer ConfigBlock传递的IL参数？

Got it, let's walk through how to get those ?Mindate and ?Maxdate parameters (passed via WebPlayer ConfigBlock, not tied to your Information Link or tables) showing up in your title area, plus fix a small issue in your IL query along the way.

第一步：修正你的Information Link SQL查询 #

First, there's a tiny syntax error in your existing query that will break it—you're missing a comma after F1."PROTOCOL_STATUS". I also noticed a potential logic issue with your date range (you had <= ?Mindate which would create an invalid range for most cases), so I adjusted that too:

SELECT 
  F1."PROTOCOL_ID", 
  F1."PROTOCOL_TYPE", 
  F1."PROJECT_CODE", 
  F1."PROTOCOL_STATUS", -- Added missing comma here
  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 -- Corrected to >= for valid date range
      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'

Double-check the date range logic against your actual business requirements—this assumes you want records where the rejected date falls between Mindate and Maxdate.

第二步：在标题区域引用ConfigBlock参数 #

Since the parameters are passed via ConfigBlock, they're available as global session parameters in WebPlayer. You can reference them directly in your title using WebFOCUS's parameter syntax (prefix with &):

• If using a Dashboard Title Component:
  Just type this into the title text field (customize the wording to fit your report):

  ECG拒签报表统计：从 &Mindate 到 &Maxdate
  

• If using a WebFOCUS TITLE command (for a standalone report):
  Add this line to your report code:

  TITLE "ECG拒签报表统计：&Mindate 至 &Maxdate";
  

第三步：验证参数传递和显示 #

To make sure everything works as expected:

• Confirm your ConfigBlock is passing the parameters with exact matching names (WebFOCUS parameters are case-sensitive—if ConfigBlock uses mindate lowercase, you need to use &mindate in the title).
• Test run your dashboard/report and check if the title shows the correct date values. If not:
  • Verify the ConfigBlock is correctly initializing the parameters in the WebPlayer session.
  • Double-check for typos in parameter names between ConfigBlock and title text.

内容的提问来源于stack exchange，提问作者Teju MB