Skip Headers
Oracle® Database Express Edition Application Express User's Guide
Release 2.1

Part Number B25309-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

6 Adding Navigation

When you build an application, you can include different types of navigation controls, including navigation bar entries, tabs, breadcrumbs, lists, and trees. This section describes how to implement navigation in your application.

Navigation controls are shared components. Once you create them, you can add them to any page within your application. You add a specific type of navigation control at the application level on the Shared Components page.

This section contains the following topics:

See Also:

Creating a Navigation Bar Entry

Navigation bar entries offer an easy way to move users between pages in an application. The location of a navigation bar depends upon the associated page template. A navigation bar entry enables you to display a link from an image or text.

Topics in this section include:

About Navigation Bars

A navigation bar entry can be an image, an image with text beneath it, or text. You must supply navigation bar entry images and text. When you create a navigation bar entry, you can specify an image, text, a display sequence, or a URL.

Description of nav_bar_2.gif follows
Description of the illustration nav_bar_2.gif

Navigation bars are different from other shared components in that you do not need to reference them on a page by page basis. If your page template includes the #NAVIGATION_BAR# substitution string, the Application Express engine automatically includes any defined navigation bars when it renders the page.

See Also:

"Supported Page Template Substitution Strings" on using the #NAVIGATION_BAR# substitution string

How to Create a Navigation Bar Entry

Before you can add a navigation bar, you must create a navigation bar entry on the Navigation Bar page. You can access the Navigation Bar page from either the Page Definition or from the Shared Components page.

Creating a Navigation Bar Entry Referencing an Icon

To create a navigation bar entry referencing an icon:

  1. Navigate to the appropriate Page Definition:

    1. Navigate to the Database Home Page.

    2. Click the Application Builder icon.

    3. Select an application.

    4. Select a page.

      The Page Definition appears.

  2. Under Shared Components, scroll down to Navigation Bar.

  3. Under Navigation Bar, click the Create icon.

    The Create Navigation Bar Entry Wizard appears.

  4. Specify the following Navigation Bar Entry attributes:

    1. Sequence - Specify the order of evaluation for this component.

    2. Alt Tag Text - Enter ALT text for navigation icons that are images. If you do not specify an image name, then this text displays.

    3. Icon Image Name - Defines the name of the image that displays.

    4. Image Height - Defines the height of the image.

    5. Image Width - Defines the width of the image.

    6. Text - Enter additional text to display with the image. You can include text or use icons with no text. This attribute is optional and can be translated.

  5. Specify the target location.

    1. If the target location is a URL:

      • From Target is a, select URL.

      • In URL Target, enter a URL.

    2. If the target location is a page:

      • From Target is a, select Page in this Application.

      • In Page, specify the page ID.

  6. If the navigation bar entry will display conditionally, specify the appropriate conditional information and click Create.

Creating a Navigation Bar Entry without an Icon

To create a navigation bar entry without icons:

  1. Navigate to the appropriate Page Definition:

    1. Navigate to the Database Home Page.

    2. Click the Application Builder icon.

    3. Select an application.

    4. Select a page.

      The Page Definition appears.

  2. Under Shared Components, scroll down to Navigation Bar.

  3. Under Navigation Bar, click the Create icon.

    The Create Navigation Bar Entry Wizard appears.

  4. Specify the following icon attributes:

    1. Sequence - Specify the order of evaluation for this component.

    2. Text - Enter additional text to display with the image. You can include text or use icons with no text. This attribute is optional and can be translated.

  5. Specify the target location.

    1. If the target location is a URL:

      • From Target is a, select URL.

      • In URL Target, type a URL. For example:

        http://www.yahoo.com
        
        
    2. If the target location is a page:

      • From Target is a, select Page in this Application.

      • In Page, specify the page ID.

  6. If the navigation bar entry will display conditionally, specify the appropriate conditional information and click Create.

Editing a Navigation Bar Entry

Once you create a navigation bar entry you can edit it on the Navigation Bar Entries page.

To edit a navigation bar entry:

  1. On the Database Home Page, click the Application Builder icon.

  2. Select an application.

  3. On the Applications home page, click Shared Components.

  4. Under Navigation, select Navigation Bar Entries.

    The Navigation Bar Entries page appears.

  5. You can change the appearance of the page by making a selection from the View list and clicking Go. Available options include:

    • Icons (the default) displays each navigation bar entry as a large icon. To edit a navigation bar entry, click the icon.

    • Details displays each navigation bar as a line in a report. To edit a navigation bar, click the appropriate sequence number.

      The Edit Navigation Bar Entry page appears.

  6. Make the appropriate edits and click Apply Changes.

Editing Multiple Navigation Bar Entries Simultaneously

To edit multiple navigation bar entries at once:

  1. On the Database Home Page, click the Application Builder icon.

  2. Select an application.

  3. On the Applications home page, click Shared Components.

  4. Under Navigation, select Navigation Bar Entries.

    The Navigation Bar Entries page appears.

  5. C lick Grid Edit.

  6. Edit the appropriate attributes and click Apply Changes.

Accessing Navigation Bar Entry Reports

You can view the Navigation Bar Entry Subscription and Navigation Bar Entry History reports by clicking the appropriate tab at the top of the Navigation Bar Entries page.

Note:

The Subscription and History buttons only appear after you create a navigation bar.

Navigation Bar Entry Subscription Report

Click Subscription to access the Subscribed NavBars report. This report displays subscribed navigation bar entries in your application.

Navigation Bar Entry History

Click History to view the Navigation Bar History report. This report lists recent changes to navigation bars.

Creating Tabs

Tabs are an effective way to navigate users between pages of an application. You can create a tabbed application look by using parent tabs, standard tabs, and lists.

Application Builder includes two different types of tabs:

An application having only one level of tabs uses a standard tab set. A standard tab set is associated with a specific page and page ID. You can use standard tabs to link users to a specific page. A parent tab set functions as a container to hold a group of standard tabs. Parent tabs give users another level of navigation as well as a context (or sense of place) within the application. You can use parent tabs to link users to a specific URL associated with a specific page.

Topics in this section include:

Note:

When running the Create Application Wizard, you have the option of creating an application with tabs. The following procedures assume you have already created an application that does not have any tabs.

About Template Support

Before you can create parent and standard tabs, you need to check that your default template has positions defined for both standard and parent tabs using the appropriate substitution strings. You also need to make sure you do not override this template at the page-level.

See Also:

About the Tabs Page

The Tabs page displays a graphical representation of the tabs defined in your application. You access the Tabs page from the Shared Components page, or by clicking the heading Tabs on the Page Definition.

Topics in this section include:

Accessing the Tabs Page from Shared Components

To access the Tabs page from the Shared Components page:

  1. On the Database Home Page, click the Application Builder icon.

  2. Select an application.

  3. On the Application Builder home page, click Shared Components.

  4. Under Navigation, select Tabs.

    The Tabs page appears displaying a graphical representation of the tabs defined in your application.

  5. To make another tab current, click the tab.

    Notice the two Add buttons. Use the Add button on the upper right side of the image to add Parent tabs. Use the Add button at the lower left side of the image to add standard tabs.

  6. To add a new tab, click Add adjacent to the appropriate tab type.

    Think of parent tabs as a container to hold standard tabs. For example, to add two levels of tabs, you first create a parent tab and then add standard tabs to it.

Accessing the Tabs Page from a Page Definition

To access Tab Manager from the Page Definition:

  1. Navigate to the appropriate Page Definition:

    1. Navigate to the Database Home Page.

    2. Click the Application Builder icon.

    3. Select an application.

    4. Select a page.

      The Page Definition appears.

  2. Under Shared Components, select the heading Tabs.

    The Tabs page appears displaying a graphical representation of the tabs defined in your application. The currently selected standard or parent tab is highlighted.

  3. To make another tab current, click the tab.

    Notice the two Add buttons. Use the Add button on the upper right side of the image to add Parent tabs. Use the Add button at the lower left side of the image to add standard tabs.

  4. To add a new tab, click Add adjacent to the appropriate tab type.

    Think of parent tabs as a container to hold standard tabs. For example, in order to add two levels of tabs you first create a parent tab and then add standard tabs to it.

Creating a New Tab from the Page Definition

To create a new tab from the Page Definition:

  1. Navigate to the appropriate Page Definition:

    1. Navigate to the Database Home Page.

    2. Click the Application Builder icon.

    3. Select an application.

    4. Select a page.

      The Page Definition appears.

  2. Under Tabs, click the Create icon.

    The Create Tab Wizard appears.

  3. Follow the on-screen instructions.

Using the Standard Tab Task List

The Standard Tab Task list displays on the right side of the Tabs page. You can access the links on this list to rename a standard tab set, resequence the display order, associate pages with a tab set, create a new standard tab, or create a new standard tab set.

To access the Standard Tab Task list:

  1. Navigate to the Tabs page:

    1. On the Database Home Page, click the Application Builder icon.

    2. Select an application.

    3. Click Shared Components.

    4. Under Navigation, select Tabs.

  2. Make a selection from the Standard Tab Task list. Available options include:

    • Rename Standard Tab Set

    • Resequence Display Order

    • Associate Page(s) with Selected Standard Tab

    • Create New Standard Tab

    • Create New Standard Tab Set

Editing Multiple Tabs at Simultaneously

You can edit multiple tabs at once by clicking Edit Standard Tabs and Edit Parent Tabs on the Tabs page.

To edit multiple tabs at once:

  1. Navigate to Tab Manager. See "About the Tabs Page".

  2. Click one of the following buttons:

    • Edit Standard Tabs

    • Edit Parent Tabs

Accessing Tab Reports

You can view the Tab Utilization and Tab History reports by clicking the appropriate tab at the top of the Tab Manager page.

Standard Tab Utilization

Click Utilization to access the Standard Tab Utilization report. This report lists the standard tabs used in the current application.

Standard and Parent Tab History

Click History to view the Standard Tab History and Parent Tab History reports. These reports display a history of changes to tab attributes for the current application.

Controlling Navigation Using Branches

A branch is an instruction to link to a specific page, procedure, or URL. For example, you can branch from page 1 to page 2 after page 1 is submitted.

Note:

If a page has a select list and a submit button, it can submit itself. However, you must create a branch to call the page or the submit will fail.

You create a new branch by running the Create Branch Wizard and specifying a the branch point and branch type. The branch type defines the type of branch you are creating.

To create a branch:

  1. Navigate to the appropriate Page Definition:

    1. On the Database Home Page, click the Application Builder icon.

    2. Select an application.

    3. Select a page.

      The Page Definition appears.

  2. Under Branches, click the Create icon.

  3. Select a branch point:

    • On Submit: Before Computation - Occurs before computations, validations, or processing. Use this option for a Cancel button.

    • On Submit: Before Validation - Occurs after computations, but before validations or processing. Typically not used. If a validation fails, page processing stops, a rollback is issued, and the page displays the error. Because of this default behavior, you do not need to create branches to accommodate validations. However, you might want to branch based on the result of a computation (for example, to the previous branch point).

    • On Submit: Before Processing - Occurs after computations and validations, but before processing. Use this option to branch based on a validated session state, but before performing any page processing.

    • On Submit: After Processing - Occurs after computations, validations, and processing. This option branches to a URL or page after performing computations, validations, and processing. When using this option, remember to sequence your branches if you have multiple branches for a given branch point.

    • On Load: Before Header - Occurs before a page is rendered. This option displays another page, instead of the current page, or redirects the user to another URL or procedure.

  4. Select a branch type.

    Depending upon the branch type, specify the following types of information on the pages that follow:

    • The page ID of the page to which you want to branch

    • PL/SQL code

    • A URL address

  5. Follow the on-screen instructions.

Creating Breadcrumbs

Breadcrumbs provide users with hierarchical navigation. A breadcrumb is a hierarchical list of links that display using templates. You can display a breadcrumb as a list of links or as a breadcrumb path.

Topics in this section include:

About Breadcrumbs

A breadcrumb trail indicates where the user is within the application from a hierarchical perspective. In addition, users can click a specific page to instantly view it. You can include a breadcrumb that functions as second level of navigation and displays beneath the standard tabs at the top of each page.

Description of menu.gif follows
Description of the illustration menu.gif

How to Create Breadcrumbs

To add a breadcrumb to a page in your application you must:

  • Create the breadcrumb by running the Create Breadcrumb Wizard.

  • Add entries to it.

  • Add the breadcrumb to a page by creating a region.

Creating Breadcrumbs from the Shared Components Page

To create breadcrumbs from the Shared Components page:

  1. On the Database Home Page, click the Application Builder icon.

  2. Select an application.

  3. On the Application Builder home page, click Shared Components.

  4. Under Navigation, select Breadcrumbs.

    The Breadcrumbs page appears.

  5. Click Create.

  6. Enter a name and click Create.

Creating Breadcrumbs from a Page Definition

To create breadcrumbs from a Page Definition:

  1. Navigate to the appropriate Page Definition:

    1. Navigate to the Database Home Page.

    2. Click the Application Builder icon.

    3. Select an application.

    4. Select a page.

      The Page Definition appears.

  2. Under Shared Components, scroll down to Breadcrumbs and click the Create icon.

  3. Enter a name and click Create.

After you create a breadcrumb, you add entries to it.

Adding Breadcrumb Entries

To add a breadcrumb entry:

  1. Navigate to the Breadcrumbs page:

    1. Navigate to the Database Home Page.

    2. Click the Application Builder icon.

    3. Select an application.

    4. On the Application Builder home page, click Shared Components.

    5. Under Navigation, select Breadcrumbs.

      The Breadcrumbs page appears.

  2. Select a breadcrumb to add entries to.

  3. Click Create Breadcrumb Entry.

  4. Under Breadcrumb Identification, specify the page on which this menu will be current

  5. Under Entry:

    1. Sequence - Indicate the order in which breadcrumb entries appear.

    2. Parent Bread Entry - Identify the parent of this entry.

    3. Short Name - Specify the short name of this entry (referenced in the breadcrumb template).

    4. Long Name - Specify the long name of this entry (referenced in the breadcrumb template).

  6. Under Target:

    If the target location is a URL:

    1. From Target is a, select URL.

    2. In URL Target, enter a URL.

    If the target location is a page:

    1. From Target is a, select Page in this Application

    2. In Page, specify the page ID

  7. You can make a breadcrumb conditional by making selections under Conditions.

    To make the breadcrumb conditional:

    1. Make a selection from the Condition Type list.

    2. Enter an expression in the fields provided.

  8. When you are finished defining menu attributes, click Create at the top of the page.

Repeat these procedures for each breadcrumb entry you need to create.

Adding a Breadcrumb Region

A region is a area on a page that serves as a container for content. Once you create a breadcrumb and a breadcrumb template, the next step is to create a region. Once you create a region you can add a breadcrumb to page.

See Also:

"Creating a New Template" and "Breadcrumb Templates" for information about changing menu display

To create a breadcrumb region:

  1. Navigate to the appropriate Page Definition:

    1. Navigate to the Database Home Page.

    2. Click the Application Builder icon.

    3. Select an application.

    4. Select a page.

      The Page Definition appears.

  2. Under Regions, click the Create icon.

    The Create Region Wizard appears.

  3. For the region type, select Breadcrumb.

  4. Enter a title and select a region template.

  5. Select a breadcrumb and a breadcrumb template.

  6. Optional. Identify the breadcrumb entry used to identify this page:

    1. Breadcrumb Entry Label - Enter a label for the breadcrumb entry.

    2. Parent Breadcrumb Entry - Select the appropriate hierarchical parent.

  7. Click Finish.

Repeat these procedures for each page where you would like to add breadcrumb navigation.

About Creating a Dynamic Breadcrumbs

To give users more exact context, you can include session state in breadcrumbs, making your breadcrumbs dynamic. For example, suppose a page in your application displays a list of orders for a particular company and you want to include the following breadcrumb:

Home > Orders > Orders for ACME Inc

In this example, ACME Inc not only indicates the page a user is on and the navigation path. The Application Express engine stores the value of ACME Inc. in session state.

To create this type of dynamic menu, you must include a reference to a session state item in the breadcrumb's short name or long name, for example:

&COMPANY_NAME.

Editing Breadcrumbs

Once you create a breadcrumb you can edit it on the Breadcrumbs page.

To edit a breadcrumb:

  1. Navigate to the Database Home Page.

  2. Click the Application Builder icon.

  3. Select an application.

  4. On the Application Builder home page, click Shared Components.

  5. Under Navigation, select Breadcrumbs.

    The Breadcrumbs page appears.

    You can change the appearance of the page by making a selection from the View list. Available options include:

    • Icons (the default) displays each breadcrumb as a large icon. To edit a breadcrumb, click the icon.

    • Details displays each breadcrumb as a line in a report. To edit a breadcrumb, select the appropriate name.

Accessing Breadcrumb Reports

You can view the Breadcrumb Utilization and Breadcrumb History reports by clicking the appropriate tab at the top of the Breadcrumbs page.

Note:

The Utilization and History buttons only appear after you create a breadcrumb.

Breadcrumb Utilization Report

Click Utilization to access the Breadcrumb Utilization report. This report lists breadcrumbs by page. Click the page ID to link to a specific page.

Breadcrumb History Report

Click History to view the Breadcrumb History report. This report lists recent changes to breadcrumbs.

Creating Lists

A list is a shared collection of links. You control the appearance of a list through list templates. 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. You further specify what current looks like using template attributes. You add a list to a page by creating a region and specifying the region type as List.

Description of list.gif follows
Description of the illustration list.gif

Topics in this section include:

See Also:

"Creating a New Template" and "List Templates" for information about altering list display

Creating a List

To add a list to a page in your application you must:

  1. Create the list by running the Create Lists Wizard.

  2. Add items to the list.

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

Creating a List from the Shared Components Page

To create a list from the Shared Components page:

  1. On the Database Home Page, click the Application Builder icon.

  2. Select an application.

  3. On the Applications home page, click Shared Components.

  4. Under Navigation, select Lists.

    The Lists page appears.

  5. To create a new list, click Create.

  6. In the fields provided:

    1. Enter a name for the list.

    2. Select a list template.

    3. If applicable, select a build option for this component. Build options are predefined settings that determine whether or not components within an application are enabled.

  7. Click Create.

Creating a List from a Page Definition

To create a list from a Page Definition:

  1. Navigate to the appropriate Page Definition:

    1. Navigate to the Database Home Page.

    2. Click the Application Builder icon.

    3. Select an application.

    4. Select a page.

      The Page Definition appears.

  2. Under Shared Components, scroll down to Lists and click the Create icon.

  3. In the fields provided:

    1. Enter a name for the list.

    2. Select a list template.

    3. If applicable, select a build option for this component. Build options are predefined settings that determine whether or not components within an application are enabled.

  4. Click Create.

Once your list is created, you need to add entries to it.

Adding List Entries

You can 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.

To add an entry to a list:

  1. Navigate to the Lists page.

  2. Select a list.

  3. Click Create List Entry.

    The Create / Edit List Entry page appears.

  4. Under Label and Sequence:

    1. Parent List Item - Identify the parent for this list entry. Use this attribute if you are creating a hierarchical list that will contain a sublist.

    2. Sequence - Indicate the order in which list entries appear.

    3. Image - Identify the file name for the image used to display this list entry. Control over this attribute is provided by list templates.

    4. Image 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 allows for the title image attribute to be automatically set based on the value of the list label text. For example:

      title="#LIST_LABEL#"
      
      
    5. List Entry Label (required) - Enter the label text for this link (required).

  5. Specify a target location.

    If the target location is a page:

    1. From Target Type, select Page in this Application.

    2. In Page, specify the target page ID.

      To reset pagination for this page, select reset pagination for this page.

    3. In Request, specify the request to be used.

    4. In Clear Cache, specify the pages (that is, the page IDs) on which to clear cache. Specify multiple pages by listing the page IDs in a comma-delimited list.

      You can set session state (that is, give a listed item a value) using the next two attributes:

    5. To set session state:

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

      • In 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\).

    If the target location is a URL:

    1. From Target type, select URL.

    2. In URL Target, enter a URL.

  6. Under Current List Entry Identification:

    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 - Based on the selection above, define a condition to evaluate. When this condition is true then the list item becomes current.

  7. To make the list entry conditional:

    1. Make a selection from the Condition Type list.

    2. Enter an expression in the fields provided.

  8. When you are finished defining list attributes, click Create or Create and Create Another.

Adding a List to a Page

Once you create a list, the next step is to add it a page by creating a region and specifying the region type as List.

See Also:

"Creating a New Template" and "List Templates" for information about altering list display

To add a list to a page:

  1. Navigate to the appropriate Page Definition:

    1. Navigate to the Database Home Page.

    2. Click the Application Builder icon.

    3. Select an application.

    4. Select a page.

      The Page Definition appears.

  2. Under Regions, click the Create icon.

  3. Select List as the region type.

  4. Specify the following display attributes:

    • Title - Enter a title for the region. This title will display if the region template you choose displays the region title.

    • Region Template - Choose a template to control the look of the region.

    • Display Point - Identify a display point for this region.

      Two types of display points exist: page template positions and page body positions. Page template positions are controlled by page template substitution strings (#REGION_POSITION_01#..#REGION_POSITION_08#). Page template positions allow for exact placement of a region within a page template. Page body positions are displayed where the #BODY# substitution string in the page template indicates.

    • Sequence - Specify the sequence for this component. The sequence determines the order of evaluation.

    • Column - Indicate the column in which this region is to be displayed. A page can have multiple regions, these regions can be displayed in different columns. Please note that this attribute only applies to regions that are displayed in a Page Template Body position.

  5. From List, select the list you want to add.

  6. Click Create List Region.

Repeat these procedures for each page on which you would like to add a list.

Editing Lists

Once you create a list you can edit it on the Lists page.

To edit a list:

  1. Navigate to the Lists page.

    From the Page Definition:

    1. Navigate to the Database Home Page.

    2. Click the Application Builder icon.

    3. Select an application.

    4. Select a page.

    5. Under Shared Components, select the title Lists.

    From the Shared Components page:

    1. Navigate to the Database Home Page.

    2. Click the Application Builder icon.

    3. Select an application.

    4. On the Applications home page, click Shared Components.

    5. Under Navigation, select Lists.

      The Lists page appears.

  2. You can change the appearance of the page by making a selection from the View list. Available options include:

    • Icons (the default) displays each list as a large icon. To edit a list, click the appropriate icon.

    • Details displays each list as a line in a report. To edit a list, click the list name.

Editing Multiple List Entries Simultaneously

You can edit multiple list entries at once by clicking Grid Edit on the List Entries page.

To edit multiple list entries at once:

  1. On the Database Home Page, click the Application Builder icon.

  2. Select an application.

  3. On the Application Builder home page, click Shared Components.

  4. Under Navigation, select Lists.

    The Lists page appears.

  5. Select a list name.

    The List Entries page appears.

  6. Click Grid Edit.

  7. Edit the appropriate items and click Apply Changes.

Accessing List Reports

You can view the List Utilization by Page, Unused Lists, and List History reports by clicking the appropriate tab at the top of the Lists page.

Note:

The List Utilization, Unused Lists, and History buttons only appear after you create a list.

Utilization

Click List Utilization to access the Lists Utilization report. This report displays all lists included in the current application. To edit list entries, select the list name. To view the pages on which the list appears, click the number in the Pages column.

Unused

Click Unused to identify lists that are not used in the current application.

History

Click History to view changes to list definitions and list entries by developer and date.

Creating Trees

You can use a tree in your application to effectively communicate hierarchical or multiple level data.

Topics in this section include:

Creating a Tree

To create a tree:

  1. Navigate to the Shared Components page:

    1. Navigate to the Database Home Page.

    2. Click the Application Builder icon.

    3. Select an application.

    4. On the Application Builder home page, click Shared Components.

  2. Under Navigation, select Trees.

    The Trees page appears.

  3. To create a new tree, click Create.

  4. Enter basic page information.

  5. Specify how tabs should be implemented.

  6. Enter a Tree Name and specify number of default expanded levels.

  7. Select a tree template.

  8. To display a tree, you need to specify a starting point. Depending on your Start Tree selection, enter either a query or a single value.

  9. Identify whether to include Collapse All, Expand All, or Reset Tree buttons.

  10. Specify the owner and name of the table on which the tree will be based.

  11. A tree is based on a query and returns data that can be represented in a hierarchy. Identify the column you want to use as the ID, the Parent ID, and specify the text that should appear on the leaf nodes.

    1. I D - Enter the column you want to use as the ID.

    2. Parent ID - Enter the Parent ID.

    3. Leaf Node Text - Specify the text that should appear on the leaf nodes.

    4. Link Option - Select Existing Application Item to make the leaf node text a link. If you select this option, specify a page to link to.

  12. Optional. Identify an optional where and order by clause to add to your query.

  13. Specify the display text for the Go button.

  14. Identify the page you want to branch to when the user clicks a button.

  15. Click Finish.

Editing a Tree

Once you create a tree you can edit it on the Trees page.

To edit a tree:

  1. On the Database Home Page, click the Application Builder icon.

  2. Select an application.

  3. On the Applications home page, click Shared Components.

  4. Under Navigation, select Trees.

    The Trees page appears.

  5. You can change the appearance of the page by making a selection from the View list. Available options include:

    • Icons (the default) displays each tree as a large icon. To edit a tree, click the icon.

    • Details displays each tree as a line in a report. To edit a tree, click the appropriate name.

Accessing Tree Reports

You can view the Trees Utilization and Tree History reports by clicking the appropriate tab at the top of the Trees page.

Note:

The Utilization and History buttons only appear after you have created a tree.

Tree Utilization

Click Utilization to access the Tree Utilization report. This report displays all trees included in the current application. To edit a tree, select the tree name.

Tree History

Click History to view changes to trees by developer and date.