Review the components that comprise a smart filters page by viewing attributes in Page Designer.

To review the components of a smart filters page:

1. View the page in Page Designer:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. Select a page.
   Page Designer appears.
2. Review the Search region. In the Rendering tab, locate and select the Search region.
   
   Description of the illustration smart_filters_srch_region.png

   Note the Search region Type is Smart Filter. In this example, the Search region contains six filters. Filters display in runtime as suggestion chips with counts that show how often the specific value occurs. The value shown in the suggestion chip is configured with the attributes in the Suggestions group. Filters are similar to items but feature the following unique characteristics:

   • Naming Conventions - Filters use the same naming convention as items. By default, wizards prefix filter names with P<page no>_<item name> (for example, P2_SEARCH).

   • Associated with a Column - Filters are associated with a column from the Search Results (or report) region.

   • Checkbox Group Filters - The filters with the Type Checkbox Group create a UI for selecting or entering the filter values. They are not implemented the same as page items even if they have the same type name. For this reason, most dynamic actions do not apply to filters.

3. Select a filter and explore the configurable options.
   To view Help, select the attribute and click the Help tab.
4. Review the report region. In the Rendering tab, locate and select the Search Results (or report).
   
   Description of the illustration smart_filters_srch_results.png

   In the previous example, note that the attributes indicate the report Type is a Classic Report built on the EBA_PROJECT_TASKS table in a local database:

Learn about the regions that comprise a smart filters page.

About the Search Region

A smart filters page features a Search region which enables users to narrow down the search result and a report region such as classic report or cards report.

In Page Designer, the Search region displays in the left pane or Rendering tab. Selecting the Search region displays attributes in the Property Editor. In the following image, the Search region Type is defined as Smart Filters. The Filtered Region attribute identifies the Search Results region. In this example, Filtered Region is as a classic report named Search Results.

Description of the illustration smart_filters_srch_region2.png

Tip:

Remember that each attribute in the Property Editor has associated Help. To view Help, select the attribute in the Property Editor and then click the Help tab in the central pane. Help describing the attribute appears in the central pane.

About the Search Results

A smart filters page includes a Search Results region. If you create a smart filters page using either the Create Application Wizard or Create Page Wizard, the Search Results region is either a classic report or cards report. If you create a smart filters page manually, the Search Results region can also be a manually created map or calendar. In the following example, Search Results is a classic report built on the EBA_PROJECT_TASKS table.

Description of the illustration smart_filters_srch_results2.png

Add new filters in Page Designer by right-clicking Filters and selecting Create Filter from the context menu.

To create a Range filter:

1. View the smart filters page in Page Designer.
2. In the Rendering tab, right-click Filters and select Create Filter.
3. Select the new filter and edit the following filter attributes in the Property Editor:
   1. Identification, Name - Enter PX_SAL where X represents the page number.
   2. Identification, Type - Select Range.
   3. Label, Label - Enter Salary
   4. Source, Database Column - Verify that the column is SAL.
   5. Source, Data Type - Select NUMBER.
   6. Settings, Select Multiple - Enable Select Multiple.
4. Define the filter as a static list of values:
   1. List of Values, Type - Select Static Values.
   2. List of Values, Static Value - Click Display1, Display2.

      In the Static Values dialog, define the following:

      • Row 1:

        Display Value - Enter <900

        Return Value - Enter |900

      • Row 2:

        Display Value - Enter 900 - 1#G#300

        Return Value - Enter 900|1300

      • Row 3:

        Display Value - Enter 1#G#300 - 2#G#000

        Return Value - Enter 1300|2000

      • Row 4:

        Display Value - Enter 2#G#000 - 2#G#500

        Return Value - Enter 2000|2500

      • Row 4:

        Display Value - Enter 2#G#000 - 2#G#500

        Return Value - Enter 2500|

        
        Description of the illustration smart_filter_static_values.png

      • Click OK to save your changes.

5. Configure the Suggestions attributes for the the PX_SAL filter:
   1. Select the the PX_SAL filter (if not already selected).
   2. Suggestions, Static Values - Select how suggestions are determined for this filter. Options include:

      • Dynamic - Picks the first visible entry from the List of Values.

      • Static Values - Enter a comma delimited list of values.

      • SQL Query - Values are returned from the SQL Query entered.

      For this example, select Static Values.

   3. Suggestions, Static Values - Enter 2000|2500

      This will display 2,000 - 2,500 on the suggestion chip at runtime.

   4. Save your changes. Click Save.
6. View the page.
   1. Click Save and Run Page in the upper right corner.
   2. If prompted, enter your workspace username and password and click Sign In.

      The revised page appears. Notice that a Salary suggestion chip appears that reads:

      Salary 2,000 - 2,500 (1)

      
      Description of the illustration new_filter_runtime.png
   3. Select the Salary on the Salary suggestion chip.

      The revised page appears. Notice that the Salary suggestion chip has become an applied filter chip and moved to the Applied Filters Area.

   4. Test the new filter. To remove a filter, click the X after the filter name.

Edit attributes to change filter behavior.

To view and edit filter attributes:

1. View the smart filters page in Page Designer.
2. View the filter attributes, P2_PROJECT_ID:
   1. In the Rendering tab (or left pane) locate the Search region and select the filter, P2_PROJECT_ID.
   2. In the Property Editor (or right pane) find the List Entries group.
      
      Description of the illustration view_filter_att.png

      Tip:

      The maximum amount of items which can be returned by an LOV, or by Distinct Values, is 5,000. If an LOV returns more than 5,000 items, search cuts the LOV silently at 5,000 values. When logged in as a developer, APEX raises a runtime error once more than 2,000 LOV items are returned. These errors indicate that the LOV returns too many values for a useful search UI.
   3. In the Property Editor, find the Source group.

      The Source group indicates that the P5_PROJECT_ID filter is based on the PROJECT_ID column which has a data type of Number.

      
      Description of the illustration view_filter_source_att.png
3. Update P2_PROJECT_ID and enable the Client-Side Filtering attribute:
   1. In the Rendering tab, select the P2_PROJECT_ID filter (if not already selected).
   2. In the Property Editor, find List Entries and enable Client-Side Filtering. Enabling this option renders a search field above the list entries.
      
      Description of the illustration filter_client_side_att.png
   3. Review your changes. Click Save and Run Page.

      Click the name Project on the Project suggestion chip. Notice a Filter Project search field appears above the list.

      
      Description of the illustration filter_client_side_att_run.png
   4. Test the new Filter Project field. For example, entering the keyword "develop" will update the Project list to only include filters containing that phrase.
   5. Click Page XX on the Runtime Developer Toolbar to return to Page Designer, where XX is the page number.
4. Only show Milestones for the selected Project by enabling the Depending On attribute.
   1. In the Rendering tab locate the Search region and select the P5_MILESTONE_ID filter.
   2. In the Property Editor, find Depending On, Filter and select P2_PROJECT_ID.
   3. Review your changes. Click Save and Run Page.

      The Smart Filters page appears. Note that the Milestone suggestion chip no longer displays.

   4. Click Project on the Project suggestion chip and then select a project such as Develop Production Partner Portal

      Note the Milestone suggestion chip displays again.

      
      Description of the illustration filter_depending_att_run.png