8.6.2 About Creating Facet Search Pages

Create a faceted search page by running either the Create Application Wizard or Create Page Wizard.

Both the Create Application Wizard and Create Page Wizard support the creation of a faceted search page which contains a left Search region and a report. You choose if the report is a classic report or a cards report.

About Auto-Discovered Facets

When you build a faceted seach page with either wizard, you can select a table or view on which to build the page. If you create the page based on a table, the facets are auto discovered using the Data Dictionary Cache. In contrast, if you build the page on a view or a SQL query, the facets are not auto-discovered. Instead, the wizard creates a facet region which only searches VARCHAR2 columns.

About the Data Dictionary Cache

The Data Dictionary Cache report displays statistics and a data analysis of schema tables and caches in a workspace. Both the Create Application Wizard and Create Page Wizard use the Data Dictionary Cache when creating new applications and pages. You can preview how the wizards will render facets on the Data Dictionary Cache page by viewing the Table Column Cache report. The wizard uses the first top five facet search score columns with score greater than or equal to 20.

If a table changes due to DDL or DML modifications, the Oracle Application Express nightly job ORACLE_APEX_DICTIONARY_CACHE refreshes the Data Dictionary Cache. However, you can refresh the cache manually by navigating to the Data Dictionary Cache and clicking either Gather Statistics and Refresh Cache or Refresh Cache Only at the workspace or table-level.

See Also:

Accessing the Data Dictionary Cache Report from Workspace Administration or Accessing the Data Dictionary Cache Report from Administration Services in Oracle APEX Administration Guide