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}.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"page_id": "<page_id>",
"region_name": "<region_name>",
"sql_query": "<sql_query>"
},
"name": "apex_add_icon_list"
}
}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 |