apex_add_status_matrix
Add a status matrix grid to an Oracle APEX page. Use a SQL query to define rows and columns with colored status cells for clear status visualization.
Instructions
Add a status matrix grid (rows × columns with colored status cells).
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_status_matrix"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page_id | Yes | Target page ID. | |
| sequence | No | Display order on page. | |
| sql_query | Yes | SQL returning label and status columns. | |
| custom_css | No | ||
| region_name | Yes | Region display name. | |
| group_column | No | Optional column for category grouping label. | |
| label_column | No | Column for item name. | LABEL |
| status_column | No | Column with status text (e.g., 'Ativo', 'Inativo', 'Pendente'). | STATUS |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |