Skip to main content
June 27, 2025
Solved

WfTime parameter not working in SQL table editor

  • June 27, 2025
  • 2 replies
  • 1 view

Hi everyone,

I'm currently working on a dashboard that, through the use of a SQL table editor, will show data stored in a table. Below an example of one row from that table:



The interface of the SQL table editor allows me to filter the data to show only specific rows, and I added a filter for the columns T_ENTITY and PERIOD:



 

The first filter (T_ENTITY) works as expected. The second filter should filter out those rows in the table whose Period differs from the one selected by the user in the WF. Nevertheless, if I use |WFTime| as parameter, it doesn't show any row, even those that have the same Period as the WF. If I instead replace |WFTime| with the static period (es 'PERIOD = '2022M11'),  it works fine. 

The conclusion I take is that |WFTime| is not equal to the current WF period. To check that out, I added the following label to the dashboard header, setting its value equal to |WFTime|:



and it shows exactly the current WF period:



Is it possible that the parameter |WFTime| does not work as a filter for a SQL table editor? Or am I missing something?

Thanks in advance for the help!

Best answer by BenEppel

Does having = '|WFText4|' and Period = '|WFTime|' work?

 

If that doesn't fix the issue you could create an XFBR string that accepts WFTime and WFText4 as variables, and then create the where clause in the xfbr.

2 replies

BenEppelAnswer
June 27, 2025

Does having = '|WFText4|' and Period = '|WFTime|' work?

 

If that doesn't fix the issue you could create an XFBR string that accepts WFTime and WFText4 as variables, and then create the where clause in the xfbr.

June 28, 2025

This. That WHERE is simply dropped into an SQL statement, so it needs to be quoted accordingly.

Reason #7492 to use Dynamic Grids instead...

fc5Author
June 30, 2025

The solution was right there but it didn't cross my mind :) 
Thank you both