apex_add_comparison_panel
Add a side-by-side comparison panel to an Oracle APEX page, displaying two columns of metrics for direct comparison between two data sets or periods.
Instructions
Add a side-by-side comparison panel (two columns of metrics).
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>",
"left_label": "<left_label>",
"left_metrics": "<left_metrics>",
"right_label": "<right_label>",
"right_metrics": "<right_metrics>"
},
"name": "apex_add_comparison_panel"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page_id | Yes | Target page ID. | |
| sequence | No | Display order on page. | |
| custom_css | No | Additional CSS rules injected into the style block. | |
| left_color | No | Accent color for left column. | blue |
| left_label | Yes | Header for the left column (e.g., "Periodo Anterior"). | |
| region_name | Yes | Internal region name. | |
| right_color | No | Accent color for right column. | green |
| right_label | Yes | Header for the right column (e.g., "Periodo Atual"). | |
| left_metrics | Yes | Metrics for left column. Each dict: {"label": "Total", "sql": "SELECT COUNT(*) FROM ...", "suffix": ""} | |
| right_metrics | Yes | Metrics for right column (same format as left_metrics). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |