Cards

A cards page consists of individual boxes, which resemble index cards, laid out on a page. Each card displays three pieces of information: Card Title, Description Column, and Additional Text Column. First, you select a table or view on which to build the page. Second, you select the Card Title, Description Column, and Additional Text Column.

See: Managing Cards

Faceted Search

Creates a faceted search page which contains a left Search region and a report.

You select a table or view on which to build the page. The wizard shows facet selections with options, enabling you to select or deselect the facet columns. When a page is based on local table, then facet recommendations display based on the statistics of the data in the selected table. In all other cases (that is, when the page is not based on local table), only VARCHAR2 columns are displayed for facet selections. You choose if the report is a classic report or a cards report.

See: Managing Faceted Search

Smart Filters

A smart filters page features a single search field at the top of the page with filters that display suggestion chips. While a smart filters page behaves similarly to faceted search, a smart filters page features a more space efficient layout.

You select a table or view on which to build the page. When a page is based on local table, then filter recommendations are displayed based on the statistics of the data in the selected table. In all other cases (that is, when the page is not based on local table), only VARCHAR2 columns are displayed for filter selection.

Each suggestion chip displays a single count for the specific suggestion values. The suggestion chip count only displays for filters that support counts, such as LOV-based filter types. Users can search or click a suggestion chip to quickly filter the report. You choose if the report is a classic report or a cards report.

See: Managing Smart Filters

Interactive Grid

An interactive grid presents users a set of data in a searchable, customizable report. Functionally, an interactive grid includes most customization capabilities available in interactive reports plus the ability to rearrange the report interactively using the mouse or keyboard.

Enabling Include Form Page includes a modal form page. Then, you select the Data Source and the Source Type (that is, Table or SQL Query).

If the Data Source contains BLOB columns, then those columns are automatically excluded from the region source since interactive grid regions do not support BLOB columns. If the Data Source is a local table which has foreign keys selected, then for those columns, the column type is set as Select List. If a if matching LOV already exists, a Shared LOV is automatically created or re-used.

You determine if the interactive grid is editable by enabling or disabling Editing Enabled. When this option is enabled, then the grid is rendered read-only and separate form page is created to create and edit the data.

See: Managing Interactive Grids

Interactive Report

Creates a page that contains the formatted result of a SQL query. Enabling Include Form Page includes a modal form page. Then, you select the Data Source and the Source Type (that is, Table or SQL Query).

If a Data Source contains BLOB columns and if a local table with primary key constraints is selected as the Data Source, then BLOB columns are set as Download BLOB type, with proper BLOB attributes. If the Data Source is a local table, which has foreign keys selected, then for those columns, the column type is set as Plain Text (based on List of Values). If a if matching LOV already exists, a Shared LOV is automatically created or re-used.

See: Managing Interactive Reports

Classic Report

Creates a page that contains the formatted result of a SQL query. You choose a table on which to build a report or provide a custom SQL SELECT statement or a PL/SQL function returning a SQL SELECT statement.

When a Data Source contains BLOB columns and if a local table with primary key constraints is selected as the Data Source, then BLOB columns are set as Download BLOB type, with proper BLOB attributes. When a local table, which has foreign keys is selected as the Data Source, then for those columns, column type is set as Plain Text (based on List of Values). If a if matching LOV already exists, a Shared LOV is automatically created or re-used.

Enable Include Form Page to include a form page for creating or updating records.

With the exception of sorting and simple filtering, end users cannot customize a classic report.

See: Managing Classic Reports