Previous Next JavaScript must be enabled to correctly display this content

## 8.6.4 Creating Smart Filters Using the Create Page Wizard

Run the Create Page Wizard to add a new smart filters search page to an existing application.

If you are using the latest Universal Theme, breadcrumbs function a little differently when adding a new smart filters page using the Create Page Wizard. If breadcrumbs are disabled, the Smart Filters region is added to the Body container. However, if breadcrumbs are enabled, the Smart Filters region is added to the Breadcrumb container and a Breadcrumb displays at the top the page.

Tip:

To learn more about breadcrumbs, see Editing Breadcrumbs

To create a smart filters page by running the Create Page Wizard:

1. On the Workspace home page, click the App Builder icon.
2. Select the application.
3. Click Create Page.

   Create a Page appears.

4. Click Component and select Smart Filters.
5. Under Page Definition:
   1. Page Number - The page number is an integer value that identifies a page within an application.
   2. Name - Specify a text name for this page.

      Tip:

      This text is also used for page Title. After page creation, you can modify the Title in Page Designer.
6. Data Source - Select a Data Source for the page:

   - Local Database - Data is sourced from a local database.

   - REST Enabled SQL - Data is sourced from a remote database, where the connection is defined using REST Enabled SQL. To create or maintain REST Enabled SQL references, navigate to Shared Components, REST Enabled SQL Databases.

   - REST Source - Data is sourced from a RESTful web service defined using REST Data Sources. To create or maintain REST Data Sources, navigate to Shared Components, REST Data Sources.

   - Duality View - Data is sourced from a Duality View Source defined using Duality Views within Shared Components.

   - JSON Source - Data is sourced from a JSON Source defined using JSON Sources within Shared Components. JSON Sources include tables with JSON columns or JSON Collection Tables.

   - Sample Data - Data is sourced from a built-in sample data set.

     If you select this option, specify Navigation preferences, skip the remaining steps, and click Create Page.

   The steps that follow differ depending upon the selected Data Source. This task assumes the Data Source is Local Database.

7. Source Type - Specify the source of the new page. Options include:
   - Table:

     - Table /View Owner - Select the owner of the table on which you are building the page.

     - Table/View Name - Select the table or view on which the page will be based.

   - SQL Query:
     - Enter a SQL SELECT statement - Enter the SQL query. To see an example, expand the SQL Query Example region.
8. Navigation - If needed, expand the region. Enable or disable the following flags:
   1. Use Breadcrumb - Enable to create a breadcrumb entry for this page. By default, the page name is used as breadcrumb entry name.
   2. Use Navigation - Enable to create a navigation menu entry for this page. By default, the page name is used as navigation menu name.

   If either flag is enabled, additional attributes appear. To learn more about an attribute, see field-level Help.

9. Click Next.
10. Display As - Select how you want to display the filtered region. Options include: Report or Cards.
11. Select filters - Select the filters include in this report.

    Filter recommendations are based on statistics of data in your table. Click Refresh to refresh the column statistics to provide better recommendations.

12. Click Create Page.

Tip:

To learn more about external data sources, see Managing REST Enabled SQL References and Managing REST Data Sources.

See Also:

Understanding Page Types in the Create Page Wizard

Parent topic: Managing Smart Filters