16.11.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.

16.11.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.

See Also:

• Adding a List to a Page

• Editing List Attributes

• Accessing List Reports

16.11.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

16.11.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, 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. Region Position - If creating a new region, select the region position.
   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.

16.11.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, select 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. Sequence - Indicate the order in which list the list entry appears. The sequence determines the order of evaluation.
   3. Image/Class - Identify an image file name or the the icon class for 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.

   4. 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#"

   5. 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#"...

   6. List Entry Label - Enter the label text for this link.
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. 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.
7. Under Conditions, specify the appropriate information to make the list entry conditional.
8. Under Authorization, you can specify an authorization scheme.

   This authorization scheme must evaluate to TRUE in order for this component to be rendered or otherwise processed.

9. Under Configuration, select a build option for this component.

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

10. Under Click Counting, specify if you want the list entries to be included in the click count.

    If this is a link to an external page, you can count clicks.

11. In User Defined Attributes, specify additional attributes. To learn more, see field-level Help.
12. When you are finished defining list attributes, click Create List Entry.

See Also:

• Editing Themes

• Optimizing a Page for Printing

• COUNT_CLICK Procedure in Oracle APEX API Reference

16.11.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, click Lists.

      The Lists page appears.

2. Select the list.
3. From Tasks list, 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.

16.11.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, click Lists.

      The Lists page appears.

2. Select the list.
3. From the Tasks list, 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.

16.11.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, click Lists.

      The Lists page appears.

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

16.11.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, click Lists.

      The Lists page appears.

2. Select the list.
3. From the Tasks list, click Resequence List Entries.
4. Click Resequence.