apex_add_faceted_search
Add faceted search filters to Oracle APEX Interactive Reports by defining facet columns, labels, and filter types. Enables users to refine report results with selectable filters.
Instructions
Add faceted search: filter SELECT_LISTs + IR. Facets: [{column, label, type}].
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| facets | Yes | List of facet descriptor dicts. Each must have: - ``"column"`` (str): Column name used in the bind variable and LOV. - ``"label"`` (str): Label shown next to the filter. - ``"type"`` (str): Filter widget type. Currently ``"checkbox"`` and ``"select"`` both produce a SELECT_LIST (with All option). - ``"lov"`` (str, optional): LOV SQL ``"SELECT display d, return r FROM ..."`` — auto-generated from ``DISTINCT column FROM table`` when omitted. Example:: [ {"column": "DS_STATUS", "label": "Status", "type": "select"}, {"column": "ID_CLINICA", "label": "Clinica", "type": "select", "lov": "SELECT DS_NOME d, ID_CLINICA r FROM TEA_CLINICAS ORDER BY 1"}, ] | |
| page_id | Yes | Target page ID. | |
| sequence | No | Display sequence for the filter region (IR gets +10). | |
| sql_query | Yes | SQL for the Interactive Report with ``:{item_name}`` bind variables matching the facet items that will be created. | |
| region_name | Yes | Display name of the main IR region. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |