apex_add_data_card_grid
Add a responsive grid of data cards to an Oracle APEX page from a SQL query. Each card shows a title, value, subtitle, and optional badge.
Instructions
Add a responsive grid of data cards. Each: {title, body, icon, badge}.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| color | No | Accent color for value and border. | blue |
| columns | No | Grid columns (2-4). | |
| page_id | Yes | Target page ID. | |
| sequence | No | Display order on page. | |
| sql_query | Yes | SQL returning title, optional subtitle, value, optional badge. Example: "SELECT DS_NOME TITLE, DS_ESPECIALIDADE SUBTITLE, COUNT(a.ID_AVALIACAO) VALUE FROM TEA_TERAPEUTAS t LEFT JOIN TEA_AVALIACOES a USING(ID_TERAPEUTA) GROUP BY DS_NOME, DS_ESPECIALIDADE" | |
| custom_css | No | Additional CSS rules injected into the style block. | |
| url_column | No | Column for card click URL (optional). | |
| region_name | Yes | Region display name. | |
| badge_column | No | Column for badge text (optional, e.g., status). | |
| title_column | No | Column for card title. | TITLE |
| value_column | No | Column for prominent numeric value. | VALUE |
| subtitle_column | No | Column for card subtitle (optional). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |