Developers can add shared collection of links (or a list) to a database application. You add a list to a page by creating a region and specifying the region type as List. You control the appearance of a list through list templates.
Topics:
See Also:
s
Oracle Application Express supports two types of lists:
Static Lists - 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 (creating from scratch), by copying existing entries, or by adding the list entries. You can control when list entries display by defining display conditions.
Dynamic Lists - Dynamic lists are based on a SQL query or a PL/SQL function executed at runtime. A dynamic list enables you to dynamically create styled list items that support mobile frameworks such as jQuery Mobile.
The list definition displays a specific type of page item, such as progress bars, sidebar, bullet navigation list, or navigation menu. You can control how a list displays through templates.
Older themes provide navigation support through the creation of tabs. Newer themes, such as Universal Theme - 42, provide navigation support through the creation of navigation menus. If the theme you are using supports navigation menus, you can create navigation menus automatically when running the Create Application Wizard. The Sample Database Application incudes a navigation menu that displays in a sidebar.
Navigation menus support the creation of hierarchical sub-menus. You can render a navigation menus either at the top of the page as tabs or as a side bar (as shown in the previous example). Navigation menus displaying as a side bar are responsive. Based on the available space, the navigation bar displays a full menu or collapses to a narrow icon bar. Side navigation menus are controlled ay the theme and user interface level.
You can select an alternative list template or change the position of a navigation menu by editing User Interface Details. You can configure the available navigation menu list templates by editing the theme.
About Switching from Tabs to Navigation Menus
Developers can switch from a theme using tabs to a theme using navigation menus if the existing application used one level of tabs was used. If an existing applications uses two levels of tabs, you must convert it to one level before changing the theme.
See Also:
This section explains about to create a static list.
Topics:
The process of creating a static list involves the following steps:
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:
To create a list from scratch:
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:
To add an entry or sublist from scratch:
See Also:
"COUNT_CLICK Procedure" in Oracle Application Express API Reference
You can copy static list entries from one list to another.
To copy list entries between lists:
Use the Reparent List Entries page to manage list entry hierarchy.
To reparent 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:
This section explains about to create a dynamic list.
Topics:
A dynamic list enables you to dynamically create styled list items that support mobile frameworks such as jQuery Mobile. Dynamic lists are based on a SQL query or a PL/SQL function returning a SQL query.
The process of creating a dynamic list involves the following steps:
Step 2: Specify whether to create the list from scratch or by copying an existing list.
Step 3: If creating a list from scratch, you are prompted to select a list type. Select Dynamic.
Step 4: Enter a SQL query or a PL/SQL function returning a SQL query.
Step 5: Add the list to a page by creating a List region.
See Also:
You create a dynamic list using a SQL query or a function returning a SQL Query.
Syntax for a SQL query:
SELECT level, labelValue label, [targetValue] target, [is_current] is_current_list_entry, [imageValue] image, [imageAttributeValue] image_attribute, [imageAltValue] image_alt_attribute, [attribute1] attribute1, [attribute2] attribute2, [attribute3] attribute3, [attribute4] attribute4, [attribute5] attribute5, [attribute6] attribute6, [attribute7] attribute7, [attribute8] attribute8, [attribute9] attribute9, [attribute10] attribute10 FROM ... WHERE ... ORDER BY ...
Syntax for a function returning a SQL query:
RETURN 'SELECT level, labelValue label,'|| ' [targetValue] target,'|| ' [is_current] is_current_list_entry,'|| ' [imageValue] image,'|| ' [imageAttributeValue] image_attribute, '|| ' [imageAltValue] image_alt_attribute,'|| ' [attribute1] attribute1,'|| ' [attribute2] attribute2,'|| ' [attribute3] attribute3,'|| ' [attribute4] attribute4,'|| ' [attribute5] attribute5,'|| ' [attribute6] attribute6,'|| ' [attribute7] attribute7,'|| ' [attribute8] attribute8,'|| ' [attribute9] attribute9,'|| ' [attribute10] attribute10'|| 'FROM ...'|| 'WHERE ...'|| 'ORDER BY ...';
Where:
level
and labelvalue
are required.
level
- For hierarchical lists, the level
parameter should be supplied. For non-hierarchical lists, this parameter can be set to NULL
.
labelvalue
- Text to appear as list entry.
targetvalue
- Target URL to branch to when list entry is selected.
is_current
- Controls the behavior of the list entry. Values include:
NULL
- Currency of target is based upon Target URL.
'YES'
- List entry is always current.
'NO
' - List entry is not current.
imagevalue
- The name of image to be display on the list entry
imageattributevalue
- Attributes of the image, such as the width or height
imagealtvalue
- Value for Image ALT
tag, required for accessibility purposes in templates where the user must click the image.
attribute1
to 10
: These attributes tie in with the existing ten User Attributes exposed on the Static List Entry page.
To create a dynamic list:
See Also:
This section discusses how to copy a list. You can copy a list from another application or from a list in the existing application.
You can copy list entries from one list to another.
To copy list entries between lists:
You can copy a list from the current application or from another application.
To copy a list:
Once you create a list and list entries, the next step is to add it to a page by creating a region and specifying the region type as List.
See Also:
To add a list to a page:
Repeat these procedures for each page where you would like to add a list.
See Also:
"List Templates" for information about altering list display
Once you create a list, you can edit it on the Lists page.
To edit a list: