apex_add_traffic_light
Add red/yellow/green traffic light indicators to Oracle APEX pages using a SQL query that returns labels and statuses. Status column values determine the color.
Instructions
Add a traffic light indicator (red/yellow/green) based on SQL value.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page_id | Yes | Target page ID. | |
| sequence | No | Display order on page. | |
| sql_query | Yes | SQL returning label and status columns. Example: "SELECT DS_NOME LABEL, CASE FL_ATIVO WHEN 'S' THEN 'GREEN' ELSE 'RED' END STATUS FROM TEA_CLINICAS ORDER BY 1" | |
| custom_css | No | ||
| region_name | Yes | Region display name. | |
| label_column | No | Column for the item label. | LABEL |
| status_column | No | Column for the status ('GREEN'/'AMBER'/'RED' or similar). | STATUS |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |