Reference Session and/or Repo Variables in URL Navigation Data Action?

Question

Is there a way to reference Session and/or Repository Variables in URL Navigation Data Actions directly?

Perhaps a syntax akin to @parameter("MyParm") or ${env:ENV_VAR}...?

As a workaround, I am creating parameters with SQL and referencing them in the action instead.

My parameter SQL looks like this: SELECT VALUEOF("REPO_VAR") FROM "Some Random Table" FETCH 1 ROWS ONLY

(Can't use "FROM DUAL" in this context...?)

Appreciate any tips, hints, or suggested refinements!

Federico Venturin - Oracle · Accepted Answer

Hi @M.K.Mori ,

I don't think repository/session variables can be referenced directly in DV data actions.

Your workaround seems to be the only way to achieve your goal atm. "FROM DUAL" can't be used in logical SQL expressions, but you can reference any dataset or subject area names used in the workbook.

I tried to use workbook calculations instead of parameters. While repository/session variable values can be read properly using the VALUEOF(...) function, calculations cannot be used in URL Navigation data actions using the ${valuesForColumn:column} syntax :(