apex_add_range_chart
Add a range chart (min-max bars) to an Oracle APEX page by specifying a SQL query that returns label, low, and high values. Visualize data ranges clearly.
Instructions
Add a range chart (min-max bars). SQL: LABEL, LOW_VALUE, HIGH_VALUE.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| height | No | Chart height in pixels. | |
| labels | No | Optional dict to override labels. Supported key: ``"series"`` (series legend label). | |
| page_id | Yes | Target page ID. | |
| sequence | No | Display order on page. | |
| animation | No | Animation style — "auto", "none", "fade", or "zoom". | auto |
| sql_query | Yes | SQL returning label, low, and high numeric columns. Example: "SELECT TO_CHAR(TRUNC(DT_AVALIACAO,'MM'),'MM/YYYY') LABEL, MIN(NR_PCT_TOTAL) LOW, MAX(NR_PCT_TOTAL) HIGH FROM TEA_AVALIACOES WHERE NR_PCT_TOTAL > 0 GROUP BY TRUNC(DT_AVALIACAO,'MM') ORDER BY 1" | |
| low_column | No | Column for minimum/low value. | LOW |
| high_column | No | Column for maximum/high value. | HIGH |
| region_name | Yes | Region display name. | |
| series_name | No | Legend name. | Range |
| label_column | No | Column for X-axis labels. | LABEL |
| y_axis_title | No | Y-axis label. | |
| zoom_enabled | No | Enable zoom on chart axes (default False). | |
| color_palette | No | List of hex colours, a named palette string, or None. | |
| scroll_enabled | No | Enable scroll on chart (default False). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |