apex_generate_report_page
Generates an Oracle APEX Interactive Report page with optional text, select, and date filter items, and includes export to CSV/Excel buttons.
Instructions
Generate an IR report page with optional filter items (text/select/date).
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| title | No | Optional region title (defaults to page_name). | |
| page_id | Yes | Page ID. | |
| sequence | No | IR region sequence. | |
| page_name | Yes | Display name. | |
| sql_query | Yes | SQL for the Interactive Report. Example: "SELECT * FROM TEA_AVALIACOES WHERE 1=1 AND (:P5_STATUS IS NULL OR DS_STATUS = :P5_STATUS)" | |
| auth_scheme | No | Authorization scheme name. | |
| filter_items | No | List of filter field dicts: [{"name": "STATUS", "label": "Status", "type": "select", "lov": "SELECT DISTINCT DS_STATUS d, DS_STATUS r FROM TEA_AVALIACOES ORDER BY 1"}, {"name": "DT_DE", "label": "Data De", "type": "date"}, {"name": "BUSCA", "label": "Pesquisa", "type": "text"}] Item names are auto-prefixed with P{page_id}_. | |
| include_export | No | Show export to CSV/Excel button (default True). |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |