Previous Next JavaScript must be enabled to correctly display this content

## 16.8.2 Creating Static Lists

A static list is based on predefined display and return values.

- About Creating a Static List
  Learn about the steps involved in creating a static list.
- About Adding Entries and Sublists to a Static List
  Once you create a list, you must add entries to it.
- Creating a Static List from Scratch
  Create a static list from scratch by running the Create List Wizard.
- Adding Entries or Sublists Manually
  Add list entries or sublists from the List Details page.
- Copying Static List Entries Between Lists
  Copy static list entries from one list to another.
- Reparenting Static List Entries
  Reparent static list entries to manage the list entry hierarchy.
- Managing Orphaned Static List Entries
  Manage orphaned list entries by removing the parent entry.
- Resequencing Static List Entries
  Resequence list entries in increments of 10 on the Clean Up page.

Parent topic: Creating Lists

### 16.8.2.1 About Creating a Static List

Learn about the steps involved in creating a static list.

A static list is based on predefined display and return values. When you create a static list you define a list entry label and a target (either a page or URL). You can add list entries when you create the list, by copying existing entries, or by adding the list entries. You can control when list entries display by defining display conditions.

The process of creating a static list involves the following steps:

- Step 1: Create the static list by either:

  - Creating a list from scratch by running the Create List Wizard. When prompted enter the list name and select the list type, Static.

  - Copying an existing static list by running the Copy List Wizard.

  Each list element has a display condition, which enables you to control when it displays. You can define a list element to be current for a specific page or for multiple pages.

- Step 2: Add list entries. You can add list entries:

  - When running the Create List Wizard.

  - By copying entries from within an existing list. If you copy an entire list, you also copy all of its list entries.

  - By adding list entries manually.

- Step 3: Add the list to a page by creating a List region.

How you perform these steps is a personal preference. You can perform all of these steps when you run the Create List Wizard. Alternatively, you can perform these steps one at a time.

Related Topics

- Adding a List to a Page
- Editing a Dynamic List
- Accessing List Reports

Parent topic: Creating Static Lists

### 16.8.2.2 About Adding Entries and Sublists to a Static List

Once you create a list, you must add entries to it.

You can add list entries when running the Create List Wizard, copying a list entry from within a list, or copying existing entries from one list to another.

You can also create hierarchical lists that contain sublists. To create a hierarchical list, you must:

- Select a list template that supports hierarchical lists.

  Tip:

  To determine if a list template supports hierarchical lists, go to Shared Components, Templates. On the Templates page, find and click the list template name. The List Template Current with Sublist Items attribute on the Edit List Template page determines whether the list template supports hierarchical lists. If this attribute is not null, the list template supports hierarchical lists. If this attribute is null, then the list template does not support hierarchical lists.

- Select a Parent List Item when you create each list entry.

See Also:

- Managing Templates

- Creating Custom Themes

- List Templates

Parent topic: Creating Static Lists

### 16.8.2.3 Creating a Static List from Scratch

Create a static list from scratch by running the Create List Wizard.

To create a static list by running the Create List Wizard:

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.
   2. Type - Select Static.
   3. Click Next.
3. For Query or Static Values:
   1. List Entry Label - Enter a numeric or alphanumeric name for the list.
   2. Target Page ID or custom URL - Select a target page or enter a custom URL.
   3. Click Next.
4. For Confirm:
   1. Create List Regions - Select whether to create a list region. Options include:

      - Do not create list region(s)

      - Create list region on current page

      - Create list region for each target page

   2. Slot - Select slot for new region.
   3. Region Template - If creating a new region, select a region template.
   4. List Template - Select the list template to use to control the appearance of your list.
   5. Click Create List.

Parent topic: Creating Static Lists

### 16.8.2.4 Adding Entries or Sublists Manually

Add list entries or sublists from the List Details page.

To add an entry or sublist manually:

1. Navigate to the Lists 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 Lists.

      The Lists page appears.

2. Select a list.

   The List Details page appears.

3. Click Create Entry.
4. Under Entry:
   1. Parent List Entry - If applicable, select the parent for this list entry. Use this attribute if you are creating a hierarchical list that contains a sublist.

      Note this attribute does not appear if you are creating the parent list entry.

   2. List Entry Label - Identify the text of the link. The display of this link text is controlled by list templates.
   3. Sequence - Indicate the order in which list the list entry appears. The sequence determines the order of evaluation.
   4. Icon - Identify the icon associated with this list entry.

      Most Universal Theme apps use the Font APEX icon library. To pick an icon, use the built-in icon picker and select an icon from the popup window. See examples below:

      - `fa-cloud` - Displays the cloud icon.

      - `fa-exclamation-circle u-danger-text` - Displays a red exclamation icon.

      To learn more, see field-level Help.

   5. Icon Attributes - Identify the image attributes (such as `width="12" height="12"`) for the list element image.

      Use the `#LIST_LABEL#` substitution string to reference the list label text. This substitution string enables the title image attribute to be automatically set based on the value of the list label text. For example:

      `title="#LIST_LABEL#"`

   6. Alt Attribute - Identify the image alt attribute for the list element image.

      Use the `#LIST_LABEL#` substitution string to reference the list label text. This substitution string enables the Alt attribute to be automatically set based on the value of the list label text. For example:

      `...alt="#LIST_LABEL#"...`

5. Specify a target type. Options include: URL or Page in this Application.

   If the target location is a URL, specify the following:

   1. Target Type - Select URL.
   2. URL Target - Enter a URL. For example:

      `http://www.example.com`

   If the target location is a page:

   1. Target Type - Select Page in this Application.
   2. Page - Specify the target page number.

      Other options include:

      - reset pagination for this page - Select this option to have the page to return to the first set of data meeting a user's new query.

      - Printer Friendly - This option displays the target page using the application's Printer Friendly template. Printer friendly templates optimize a page for printing.

   3. Request - Enter text to set the built-in application item `REQUEST`. This is also the item that is set with the name of a button that was clicked.
   4. Clear Cache - Enter the page numbers, separated by commas, for which you would like the user's session state to be cleared. To learn more, see field-level Help.
   5. To set session state (that is, give a listed item a value):

      - Set these items - Enter a comma-delimited list of item names for which you would like to set session state.

      - With these values - Enter a comma-delimited list of values for the items specified in the previous step.

      You can specify static values or substitution syntax (for example, `&APP_ITEM_NAME.`). Note that item values passed to `f?p=` in the URL cannot contain a colon. Additionally, item values cannot contain commas unless you enclose the entire value in backslashes (for example, `\1234,56\`).

6. Subentries, List - Identify the list populating subentries for this list entry. Use this attribute if you are creating a hierarchical list.

   To create a hierarchical list, you must select a list template that supports hierarchical lists. To determine which list templates support hierarchical lists, look for templates having the naming convention "with Sublist." For more information on hierarchical list item display, see list template item help.

7. Under Current List Entry:
   1. List Entry Current for Pages Type - Specify when this list entry should be current based on the page type.

      List items can be current or non-current. Current list items use the current template; non-current list items use the non-current list item template. The actual condition and templates are defined in subsequent attributes.

   2. List Entry Current for Condition - Displays conditionally. Based on the selection above, define a condition to evaluate. When this condition is true, then the list item becomes current. To learn more, see field-level Help.
8. Conditions, Condition Type -Specify the appropriate information to make the list entry conditional.
9. Authorization, Authorization Scheme - Optionally select an authorization scheme which must evaluate to TRUE in order for this component to be rendered or otherwise processed.
10. Configuration, Build Option - Select a build option for this component.

    Build options are predefined settings that determine whether components within an application are enabled.

11. Under Click Counting:
    1. Count Clicks - If this is a link to an external page, you can count clicks. See APICOUNT_CLICK Procedure in Oracle APEX API Reference.
    2. Click Count Category - See See APICOUNT_CLICK Procedure in Oracle APEX API Reference.
12. Advanced, Static ID - Enter a unique Static ID to identify this component in API calls or refer to it in application export files. If you change the Static ID, dependent components will retain their references, but any existing API calls using the old ID must be updated manually.
13. In User Defined Attributes, specify additional attributes. To learn more, see field-level Help.
14. Click Create List Entry.

Related Topics

- Editing Themes
- Optimizing a Page for Printing

Parent topic: Creating Static Lists

### 16.8.2.5 Copying Static List Entries Between Lists

Copy static list entries from one list to another.

To copy list entries between lists:

1. Navigate to the Lists page.
   1. Navigate to the Workspace home page.
   2. Click the App Builder icon.
   3. Select an application.
   4. On the Application home page, click Shared Components.
   5. Under Navigation and Search, click Lists.

      The Lists page appears.

2. Select the list.
3. From the Tasks region on the side bar, click Copy List Entries from one List to Another.
4. On Copy List Entries:
   1. Copy List Entries Select the list to copy.
   2. Click Next.
5. Click Copy List Entries.

Parent topic: Creating Static Lists

### 16.8.2.6 Reparenting Static List Entries

Reparent static list entries to manage the list entry hierarchy.

To reparent list entries:

1. Navigate to the Lists page.
   1. Navigate to the Workspace home page.
   2. Click the App Builder icon.
   3. Select an application.
   4. On the Application home page, click Shared Components.
   5. Under Navigation and Search, click Lists.

      The Lists page appears.

2. Select the list.
3. From the Tasks region on the side bar, click Reparent List Entries within this List.
4. Use the navigation bar to customize the display and click Go.
   - List - Select the list you would like to edit.
   - Start With - Restrict your view to a subset of the hierarchy.
5. To reparent entries:
   1. Select entries to reparent.
   2. Reparent To - Select a new parent.
   3. Select the entries to move and click Reparent Checked Entries.

Parent topic: Creating Static Lists

### 16.8.2.7 Managing Orphaned Static List Entries

Manage orphaned list entries by removing the parent entry.

An orphaned list entry is a list entry which has a parent, but the parent is no longer a member of the current list. When a list entry becomes orphaned, remove the parent entry.

To manage orphaned list entries:

1. Navigate to the Lists page.
   1. Navigate to the Workspace home page.
   2. Click the App Builder icon.
   3. Select an application.
   4. On the Application home page, click Shared Components.
   5. Under Navigation and Search, click Lists.

      The Lists page appears.

2. Select the list.
3. From the Tasks region on the side bar, click Manage Orphaned List Entries.
4. On Manage Orphaned List Entries:
   1. Select the entries to remove.
   2. Click Clear Parent Entries.

Parent topic: Creating Static Lists

### 16.8.2.8 Resequencing Static List Entries

Resequence list entries in increments of 10 on the Clean Up page.

To resequence list entries:

1. Navigate to the Lists page.
   1. Navigate to the Workspace home page.
   2. Click the App Builder icon.
   3. Select an application.
   4. On the Application home page, click Shared Components.
   5. Under Navigation and Search, click Lists.

      The Lists page appears.

2. Select the list.
3. From the Tasks region on the side bar, click Resequence List Entries.
4. Click Resequence.

Parent topic: Creating Static Lists