apex_add_jet_chart
Adds an Oracle JET chart region to an APEX page. Use SQL to supply LABEL and VALUE data for bar, line, pie, donut, or area charts.
Instructions
Add an Oracle JET chart region. Types: bar, line, pie, donut, area. SQL must alias LABEL + VALUE.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| height | No | Chart height in pixels (default 400). | |
| page_id | Yes | Target page ID. | |
| sequence | No | Region display order on the page. | |
| sql_query | No | SQL query returning at least 2 columns: label + value. Example: "SELECT DS_STATUS AS LABEL, COUNT(*) AS VALUE FROM TEA_AVALIACOES GROUP BY DS_STATUS" | |
| chart_type | No | Chart style: - "bar": Vertical bar chart (default) - "bar_horizontal": Horizontal bar chart - "line": Line chart (good for trends over time) - "area": Filled area chart (good for cumulative data) - "pie": Pie chart (distribution, no axes) - "donut": Donut chart (distribution with center hole) - "combo": Bar + line on same chart (use extra_series for line) | bar |
| orientation | No | "vertical" (default) or "horizontal" (for bar charts only). | vertical |
| region_name | Yes | Region title shown in the APEX page. | |
| series_name | No | Display name for the data series (shown in legend/tooltip). | |
| extra_series | No | Additional data series for multi-series charts. List of dicts: [{"sql": "...", "value_column": "VALUE", "label_column": "LABEL", "series_name": "Series 2"}] Each extra series can have its own SQL query. | |
| label_column | No | Column name used for X axis / slices (default "LABEL"). | LABEL |
| value_column | No | Column name used for Y axis / slice size (default "VALUE"). | VALUE |
| x_axis_title | No | Optional X axis label. | |
| y_axis_title | No | Optional Y axis label. | |
| color_palette | No | Optional list of hex colors for chart series (e.g., ["#00995D", "#1e88e5"]). Note: color_palette is accepted for future compatibility but not applied in APEX 24.2.13. | |
| legend_position | No | Where to show the legend: "end" (right), "top", "bottom", "start" (left), "auto". | end |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |