16.12.2 Creating Static Lists

A Static List is based on predefined display and return values.

• About the Process of Creating a Static List
  
• Creating a Static List from Scratch
  
• About Adding Entries and Sublists to a Static List
  
• Adding Entries or Sublists from Scratch
  
• Copying Static List Entries Between Lists
  
• Reparenting Static List Entries
  
• Managing Orphaned Static List Entries
  
• Resequencing Static List Entries
  

16.12.2.1 About the Process of Creating a Static List

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

• Step 1: Create the list by running the Create List Wizard.

• Step 2: Specify whether to create the list from scratch or by copying an existing list.

  You can add list entries by either creating them from scratch or by coping entries from an existing list. If you copy an entire list, you also copy all of its list entries.

• Step 3: If creating a list from scratch, you are prompted to select a list type. Select Static.

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

• Step 4: Add the list to a page by creating a List region.

How you perform these steps is a personal preference. You can perform the first three 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.12.2.2 Creating a Static List from Scratch

To create a list from scratch:

1. Access the Create/Edit Lists 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.
2. For Source, select From Scratch and click Next.
3. For Name and Type:
   1. Name - Enter a numeric or alphanumeric name for the list.
   2. Type - Select Static.
   3. Build Option - If applicable, select a build option for this component. Build options are predefined settings that determine whether components within an application are enabled.
   4. Click Next.
4. For Define List Entries, specify the following:
   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.
5. For Confirm, specify the following:
   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.12.2.3 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 creating a list from scratch, 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. To determine which list templates support hierarchical lists, look for templates having the naming convention "with Sublist."

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

See Also:

• "Creating Custom Themes"

• "List Templates"

16.12.2.4 Adding Entries or Sublists from Scratch

To add an entry or sublist from scratch:

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 the image filename or Font Awesome css class to be used to display this list entry. Control over this attribute is provided by list templates.
   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. For example, the following adds a tabindex and accesskey.
    tabindex="15" accesskey="D"
12. When you are finished defining list attributes, click Create or Create and Create Another.

See Also:

• "Editing Themes"

• "Optimizing a Page for Printing"

• "COUNT_CLICK Procedure" in Oracle Application Express API Reference

16.12.2.5 Copying Static List Entries Between Lists

You can 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 to copy.
3. On the Tasks list, click Copy List Entries from one List to Another.
4. From Copy List Entries, select the list to copy to and click Next.
5. Click Copy List Entries.

16.12.2.6 Reparenting Static List Entries

Use the Reparent List Entries page to manage 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 Start With to restrict your view to a subset of hierarchy. Make a selection and click Go.
5. From Reparent To, select a new parent.
6. Select the entries to move.
7. Click Reparent Checked Entries.

16.12.2.7 Managing Orphaned Static List Entries

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. Select the entries to remove.
5. Click Clear Parent Entries.

16.12.2.8 Resequencing Static List Entries

You can resequence list entries in increments of 10 on the Clean Up page.

To clean up 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 Clean Up List Entries.
4. Click Clean Up.