apex_add_activity_stream
Add an activity/audit stream to an Oracle APEX page with a SQL query that returns timestamp, user, and action columns, displayed in a chronological feed.
Instructions
Add an activity/audit stream. SQL must alias TIMESTAMP, USER_NAME, ACTION.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page_id | Yes | Target page ID. | |
| max_rows | No | Maximum rows to display. | |
| sequence | No | Display order on page. | |
| sql_query | Yes | SQL returning text and date columns (ORDER BY date DESC). Example: "SELECT DS_DETALHES TEXT, DT_OPERACAO DT, DS_OPERACAO ICON_COL FROM TEA_LOG_AUDITORIA ORDER BY DT_OPERACAO DESC" | |
| custom_css | No | ||
| date_column | No | Column for the timestamp (DATE or TIMESTAMP). | DT |
| icon_column | No | Column containing FA icon class per row (optional). | |
| region_name | Yes | Region display name. | |
| text_column | No | Column for the activity description. | TEXT |
| color_column | No | Column containing hex color per row (optional). | |
| default_icon | No | Default FA icon class. | fa-circle |
| default_color | No | Default accent color. | blue |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |