apex_add_timeline
Add a vertical timeline region to an Oracle APEX page by providing a SQL query that returns date, title, and body columns.
Instructions
Add a vertical timeline region. SQL must return date_col, title_col, body_col.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page_id | Yes | Target page ID. | |
| body_col | Yes | Column alias that provides the timeline item body text. | |
| date_col | Yes | Column alias that provides the date/time label. | |
| icon_col | No | Column alias that provides a Font APEX icon class (e.g., ``fa-circle``). Defaults to ``fa-circle`` when omitted or when the column is NULL. | |
| sequence | No | Region display order on the page. | |
| sql_query | Yes | SQL SELECT that must return at least the columns specified by ``date_col``, ``title_col``, and ``body_col`` (and optionally ``icon_col``). Example:: SELECT TO_CHAR(DT_AVALIACAO, 'DD/MM/YYYY') AS DT, DS_STATUS AS TITULO, DS_OBSERVACOES AS CORPO, 'fa-star' AS ICONE FROM TEA_AVALIACOES WHERE ID_BENEFICIARIO = :P10_ID ORDER BY DT_AVALIACAO DESC | |
| title_col | Yes | Column alias that provides the timeline item title. | |
| region_name | Yes | Display name of the timeline region. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |