apex_add_heatmap_grid
Create an interactive heatmap grid on an Oracle APEX page, using a SQL query to map row and column labels to color-coded cell values.
Instructions
Add a heatmap grid with color intensity based on values.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| color | No | Heatmap base color (high intensity = this color, low = tint). | blue |
| page_id | Yes | Target page ID. | |
| sequence | No | Display order on page. | |
| sql_query | Yes | SQL returning ROW_LABEL, COL_LABEL, VALUE. Example: "SELECT TO_CHAR(DT_AVALIACAO,'DY') ROW_LABEL, DS_STATUS COL_LABEL, COUNT(*) VALUE FROM TEA_AVALIACOES GROUP BY TO_CHAR(DT_AVALIACAO,'DY'), DS_STATUS ORDER BY 1, 2" | |
| col_column | No | Column for column labels. | COL_LABEL |
| custom_css | No | ||
| row_column | No | Column for row labels. | ROW_LABEL |
| region_name | Yes | Region display name. | |
| value_column | No | Column for numeric cell values. | VALUE |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |