16.9.6 Creating a List Search

Create a List search of an APEX List.

This topic demonstrates how create a search page based on an APEX list of search pages.

Note:

This example assumes you have already created the search pages in Creating a Standard Search Page and Creating an Oracle Text Search.

• Creating an APEX List
  Create an APEX list in Shared Components.
• Creating a List Search Configuration
  Create a List search configuration.
• Creating a List Search Page
  Create a List Search page by running the Create Page Wizard.

16.9.6.1 Creating an APEX List

Create an APEX list in Shared Components.

The following task demonstrates how to create a list on which to base a List search.

See Also:

Creating Static Lists

To create a static list:

1. Access the Create List Wizard:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. On the Application home page, click Shared Components.
   4. Under Navigation and Search, click Lists.
   5. Click Create.
   The Create List Wizard appears.
2. For Name and Type:
   1. Name - Enter a numeric or alphanumeric name for the list (for example, Project Pages List).
   2. Type - Select Static.
   3. Click Next.
3. For Query or Static Values - Enter the labels and target pages. For example:
   1. Row 1:
      • List Entry Label - Search Projects - Standard
      • Target Page ID or custom URL - 7
   2. Row 2:
      • List Entry Label - Search Tasks - TEXT
      • Target Page ID or custom URL - 10
   3. Click Next.
4. Click Create List.
5. Click the Application ID breadcrumb to return to the Application home page.

16.9.6.2 Creating a List Search Configuration

Create a List search configuration.

A search configuration contains information about searchable data source. This task creates a search configuration using the list you created in Creating an APEX List.

To create a List search configurations:

1. Access the Search Configurations page:
   1. On the Workspace home page, click the App Builder icon.
   2. Select an application.
   3. On the Application home page, click Shared Components.
   4. Under Navigation and Search, click Search Configurations.
      The Search Configurations page appears.
2. On the Search Configurations page, click Create.
   The Create Search Configuration Wizard appears.
3. Detail:
   1. Name - Enter a name for the search configuration (for example, Search Project Page - List).
   2. Search Type - Select a type of search. Options include:

      • Standard - Defines a searchable data source such as a table, SQL Query, or REST Data Source. Searches is executed by a SQL Query using LIKE expressions.

      • Oracle TEXT - Define a searchable table or SQL Query which already has an Oracle TEXT index created. Search is executed by using Oracle TEXT functionality, which provides linguistic and fuzzy search capabilities.

      • Oracle Ubiquitous Search - Search using an Oracle ubiquitous search index (requires Oracle Database 23ai or later). The index must be located in the parsing schema of the application.

      • List - Search within a selected List from Shared Components.

      For this example, select List.

   3. List - Select this list you previously created (for example, Project Pages List).
   4. Click Next.
4. Column Mapping:
   1. Primary Key Column - Select the primary key column for the search configuration Data Source (for example, LIST_ENTRY_ID).
   2. Title Column - Select the column to be used as title (for example, ENTRY_TARGET).
   3. Description Column - Select the column to be used as the description (for example, ENTRY_TEXT).
   4. Icon Source - Configure the icon that displays in the header of the search result. Options include:
      • Initials - Use the Title column to display the icon as initials.
      • CSS Classes - Use the entered CSS classes to display the icon.
      • Class Column

      For this example, accept the default, Initials.

5. Click Create Search Configuration.

   The search configuration is created and the Search Configuration, Edit page appears and displays the message Search configuration created.

6. Click the Application ID breadcrumb to return to the Application home page.

16.9.6.3 Creating a List Search Page

Create a List Search page by running the Create Page Wizard.

A Search page features a Search field and a Search Results region. In Page Designer, the Search Results region contains Search Sources which map to the search configurations defined in Shared Components.

When you create a search page with the Create Page Wizard, the wizard creates a Search field for you and prompts you to select search configurations. You can also add additional search configurations later in Page Designer.

To create a search page by running the Create Page Wizard:

1. Navigate to the Application home page:
   1. On the Workspace home page, click the App Builder icon.
   2. Select the application.
2. On the Application home page, click Create Page.
   Create a Page appears and features three tabs: Component, Feature, and Legacy Pages.
3. Under Component, select Search Page.
4. 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 (for example, Search Project Pages List).

      This text is also used for page Title. After page creation, you can modify the Title in Page Designer.

   3. Page Mode - Identify the page mode. Accept the default, Normal.
5. Search Configurations - Select the search configuration to be used by this page (for example, select Search Project Page - List).
   
   Description of the illustration list_create_search_page.png
6. Navigation - Accept the default and enable Use Breadcrumb and Use Navigation.
7. Click Create Page.

   Page Designer appears.

   
   Description of the illustration list_search_page_created.png

   In the Rendering tab, notice the page item, P11_SEARCH and the Search Results region. P11_SEARCH is the search field which enables users to submit search terms. The Search Results region contains both the search results and the Search Source (Search Project Page - List) which maps to search configurations maintained in Shared Components. You can further refine and control the search display and behavior by editing attributes in the Property Editor.

8. Run and test the page:
   1. Click Save and Run Page.
      The search page appears.
   2. In the search field, enter a search (for example, bug) and press Enter.

   The search results appear.

   
   Description of the illustration list_search_runtime.png