8.5.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 Application Express Administration Guide
Parent topic: Managing Faceted Search