4 Referencing Data Values in Pages

While working on your pages, you'll often need to reference the values of page items or report columns for formatting, in queries, and in business logic.

• Using Data Values in HTML Expressions
  When fine-tuning data formatting, to reference the value of page item P1_NAME use &P1_NAME. starting with an ampersand and ending with a dot. This also works to reference application items, built-in substitution strings, and column values in HTML expressions for regions like Cards, Content Row, Template Components, and Interactive Grid.
• Using Data Values in Template Directives
  Use Template Directives in your HTML expressions to conditionally format data or iterate over a list of delimited values.
• Directives Reference in Your Dock
  The Universal Theme reference app contains examples of each template directive.
• Using the Context-Sensitive Help Tab
  The context-sensitive Help tab in Page Designer is a handy resource. It's in the same tab group as the Layout tab by default.
• Using Data Values in SQL and PL/SQL
  Depending on the context, in your SQL and PL/SQL you use either :NAME bind variable syntax or GET_TYPE() functions in the APEX_SESSION_STATE package to use data values by name.