apex_add_icon_list
Add an icon list with labels to an Oracle APEX page. Use a SQL query to define items, values, and optional Font Awesome icons, with configurable colors and CSS.
Instructions
Add an icon list with labels. Each: {icon, label, description, page_id}.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| color | No | Icon accent color (named or hex). | blue |
| page_id | Yes | Target page ID. | |
| sequence | No | Display order on page. | |
| sql_query | Yes | SQL returning label/value and optionally icon columns. Example: "SELECT DS_STATUS LABEL, COUNT(*) VALUE FROM TEA_AVALIACOES GROUP BY DS_STATUS ORDER BY 1" | |
| custom_css | No | ||
| icon_column | No | Column containing Font Awesome class per row (optional). | |
| region_name | Yes | Region display name. | |
| default_icon | No | FA icon used when icon_column is empty or not specified. | fa-circle |
| label_column | No | Column for the item label. | LABEL |
| value_column | No | Column for the right-side value. | VALUE |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |