apex_generate_dashboard
Generate an Oracle APEX dashboard page with KPI metric cards and JET charts from SQL queries. Specify page ID and KPI definitions to create the dashboard.
Instructions
Generate a dashboard page with KPI metric cards and JET charts.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| ir_sql | No | SQL for the bottom Interactive Report. If omitted, uses a sample query. | |
| page_id | Yes | Page ID for the dashboard (typically 1). | |
| ir_title | No | Title for the IR region (default: "Recent Records"). | Recent Records |
| page_name | No | Display name (default: "Dashboard"). | Dashboard |
| kpi_queries | No | List of KPI card definitions. Each dict: { "title": "Total Users", "sql": "SELECT COUNT(*) FROM users", "icon": "fa-users", "color": "u-color-1" } If omitted, creates 4 sample KPI cards. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |