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 itemP1_NAMEuse&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:NAMEbind variable syntax orGET_TYPE()functions in theAPEX_SESSION_STATEpackage to use data values by name.