Skip Headers
Oracle® Application Express Application Builder User's Guide
Release 4.1

Part Number E21674-05
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

Managing Pages in a Database Application

A page is the basic building block of an application. When you build an application in Application Builder, you create pages that contain user interface elements, such as tabs, lists, buttons, items, and regions.

Topics:

About Creating Pages in a Database Application

You add a page or add a component to an existing page by running the Create Page Wizard. You can access this wizard by:

Note:

You can also use the Create Page Wizard to add a component (that is, a report, chart, form, wizard, a calendar, or tree) to an existing page. When prompted, specify an existing page number.

Creating a Page from the Application Home Page

To create a page from the Application home page:

  1. On the Workspace home page, click Application Builder.

  2. Select an application.

    The Application home page appears.

  3. Click the Create Page button.

  4. Select the type of page you want to create as described in the following table.

    Page Type Description
    Blank Page Creates a blank page.
    Multiple Blank Pages Creates multiple blank pages.
    Report Formatted result of a SQL query. Available options:
    • Classic Report - Creates a report based on a custom SQL SELECT statement or a PL/SQL function returning a SQL SELECT statement that you provide.

    • Interactive Report - Creates an interactive report based on a custom SQL SELECT statement you provide. Users can alter the layout of report data by selecting specific columns, applying filters, highlighting, and sorting. They can also define breaks, aggregations, different charts, and their own computations.

    • Report on Web Service Result - Creates a report on a Web Service result.

    • Wizard Report - Creates a report without requiring any SQL knowledge. Select the appropriate schema, table, columns, and result set display.

    See Also: and "Implementing Web Services"

    Form Creates a form interface with which users can update a single row or multiple rows within a table.

    See Also: "Creating Forms"

    Plug-ins Creates a new page based on a region type plug-in. Plug-ins enable developers to declaratively extend, share, and reuse the built-in types available with Oracle Application Express.

    See Also: "Importing a Plug-in from the Plug-in Page"

    Chart Enables you to create HTML and Flash graphical charts.

    See Also: "Creating Charts"

    Map Creates a Flash map based on the AnyChart AnyMap Interactive Maps Component.

    See Also: "Creating Maps"

    Tree Creates a tree to graphically communicate hierarchical or multiple level data.

    See Also: "Creating Trees"

    Calendar Generates a calendar with monthly, weekly, and daily views.

    See Also: "Creating Calendars"

    Wizard Create a wizard.
    Data Loading Creates a new data loading wizard allowing the end user to manage the loading of data into a table to all schemas for which the user has privileges

    See Also: "Creating Applications with Data Loading Capability"

    Feedback Page Adds a feedback page. Feedback is the process of gathering real-time comments, enhancement requests, and bugs from your application users.

    See Also: "Managing Feedback"

    Login Page Creates a login page.

    See Also: "About Building a Login Page"

    Access Control Creates a page containing an access control list, enabling developers to control access to an application, individual pages, or page components.

    See Also: "Controlling Access to Applications, Pages, and Page Components"


  5. Follow the on-screen instructions.

Creating a Page from the Developer Toolbar

To view a rendered version of your application, you run or submit it to the Application Express engine by clicking the Run or Run Application icon.

When you run an application, the Developer toolbar appears at the bottom of the page. The Developer toolbar offers a quick way to edit the current page, create a page, region, or page control, view session state, or turn edit links on and off. You can control whether the Developer toolbar displays by changing the Status attribute on the Edit Application page.

See Also:

"Editing the Application Definition" for information on the Status list

To create a page from the Developer toolbar:

  1. Run the application. See "Running an Application or Page".

  2. On the Developer toolbar, click Create.

    The New Component Wizard appears.

  3. Select the type of component you want to create and click Next. Available options include:

  4. Follow the on-screen instructions.

About Create Page Types

When you run the Create Page Wizard, you select a page type. Table 7-8 describes available create page options based on the type of page you select.

Table 7-8 Create Page Options

Create Page Options Available Selections

New Page

Available page types:

Region on this page

Regions function as containers for content. Available region types:

  • HTML

  • Multiple HTML

  • Report

  • Form

  • Chart

  • List

  • Breadcrumb

  • PL/SQL Dynamic Content

  • Tree

  • URL

  • Calendar

  • Plug-ins (displays if region type plug-in exists)

  • Help Text

  • Map

  • Region Display Selector

See Also: "Understanding Regions" and "About Region Types"

Page control on this page

Page controls:

Shared control

Shared component options:


Copying a Database Application Page

You can copy a page from the current application or from another application. During the copy process, you can also copy shared components or change mappings to shared components in the target application.

To copy a page:

  1. Navigate to the application you want to copy to:

    1. Navigate to the Workspace home page.

    2. Click the Application Builder icon.

    3. Select an application.

    4. Select a page.

      The Page Definition appears.

  2. In Tree view:

    1. Under Page Rendering, select the page name.

    2. Right-click and select copy.

  3. In Component view:

    1. Under Page, click the Copy icon.

    2. For Copy Page Option, select one of the following:

      • Page in this application

      • Page in another application

  4. Follow the on-screen instructions.

Running an Application or Page

The Application Express engine dynamically renders and processes pages based on data stored in database tables. To view a rendered version of your application, you run or submit it to the Application Express engine. As you create new pages, you can run them individually, or run an entire application. You can run an application by clicking the Run Application icon.

Topics:

About the Run Application and Run Page Icons

The Run Application icon resembles a large traffic light and displays on the Application home page. Clicking the Run Application icon runs an entire application.

Description of run_ico_sm.gif follows
Description of the illustration run_ico_sm.gif

The Run Page icon resembles a small, light gray traffic light and displays in the upper right corner of many pages within Application Builder. Clicking the Run Page icon runs the current page.

Description of run_ico_green.gif follows
Description of the illustration run_ico_green.gif

Running an Application from the Application Builder Home Page

To run an entire application from the Application Builder home page:

  1. On the Workspace home page, click the Application Builder icon.

  2. From the View list, select Report and click Go.

  3. Locate the application in the Applications list.

  4. Click the Run icon in the far right column.

Running an Application from the Application Home Page

To run an entire application from the Application home page:

  1. On the Workspace home page, click the Application Builder icon.

    The Application Builder home page appears.

  2. Select on application.

  3. Click the Run Application icon at the top of the page.

Running a Page on the Application Home Page

You can control how the Application home page displays by making a selection from the View list on the navigation bar at the top of the page. Selecting Details displays each page as a line in a report. Each line includes the page number, the page name, when the page was last updated, who last updated the page, a lock icon, and a Run icon.

To run a page from the Pages list:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select an application.

  3. From the View list, select Report and click Go.

  4. From the Pages list, locate the page you want to run and click the Run icon in the far right column.

Running a Page from the Page Definition

To run a specific page from the Page Definition:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select an application.

  3. Select a page.

    The Page Definition appears.

  4. Click the Run button at the top of the page.

Grouping Pages

You can make the pages within your application easier to access by organizing them into page groups. To use page groups, you create a group and then assign pages to the group.

Page groups do not have any function other than to help developers organize their application pages.

Topics:

Viewing Page Groups

The section describes different ways to view page groups.

To access the Page Groups page:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select the application.

  3. Click the Utilities icon.

  4. From Page Specific Utilities, click Cross Page Utilities.

  5. Click Page Groups.

    The Page Groups page appears.

    A Search bar displays at the top of the page. Available controls include:

    • Search columns icon - Resembles a magnifying glass. Click this icon to narrow your search. To search all columns, select All Columns.

    • Text area - Enter case insensitive search criteria (wildcard characters are implied) to search for a page group by name and then click Go.

    • Go button - Executes a search or applies a filter.

    • View. Use this control to toggle between icon and report views. To change the view, click these icons:

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

      • View Report displays each group as a line in a report. To edit a group, click the name.

    • Actions menu - Use the Actions menu to customize the report view. See "About the Actions Menu".

  6. To view the pages associated with a group, click Pages by Page Group.

Creating a Page Group

To create a page group:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select the application.

  3. Click the Utilities icon.

  4. From Page Specific Utilities, click Cross Page Utilities.

  5. Click Page Groups.

  6. On the Page Groups page, click Create.

  7. Enter a name, a description (optional), and click Create.

Editing a Page Group Definition

When you create page group you specify a name and description.

To edit the Page Group definition:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select the application.

  3. Click the Utilities icon.

  4. From Page Specific Utilities, click Cross Page Utilities.

  5. Click Page Groups.

  6. Select a page group.

  7. On the Page Group page, edit the name or description and click Apply Changes.

  8. To move to the next Page Group definition, click the Previous (<) and Next (>) buttons and repeat the previous step.

Assigning a Page to a Page Group

To assign pages to a group:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select the application.

  3. Click the Utilities icon.

  4. From Page Specific Utilities, click Cross Page Utilities.

  5. Click Page Groups.

  6. Click the Page Assignments tab.

    The Page Assignments page appears. Clicking a page number takes you to the Page Attributes page. Clicking the page Name links to the Page Definition.

  7. From the New Group list, select a group to which you want to assign pages and click Go.

  8. Select the pages to be assigned and click Assigned Checked.

Reassigning a Page to a Another Page Group

To reassign a page to a page group:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select the application.

  3. Click the Utilities icon.

  4. From Page Specific Utilities, click Cross Page Utilities.

  5. Click Page Groups.

  6. Click the Page Assignments tab.

    The Page Assignments page appears. Clicking a page number takes you to the Page Attributes page. Clicking the page Name links to the Page Definition.

  7. Select a page.

  8. From New Group, select a group to which you want to assign pages.

  9. Select the pages to be reassigned and click Assigned Checked.

Viewing Pages by Page Group

To view pages by page group:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select the application.

  3. Click the Utilities icon.

  4. From Page Specific Utilities, click Cross Page Utilities.

  5. Click Page Groups.

  6. Click the Pages by Page Group tab.

    The Pages by Page Group page appears. Clicking a page number takes you to the Page Attributes page. Clicking the page Name links to the Page Definition.

  7. To create a new group, click Create and follow the on-screen instructions.

Deleting a Page Group

To remove a page group:

  1. Remove all pages from the group to be deleted. See "Viewing Pages by Page Group".

  2. Access the Page Group page:

    1. On the Workspace home page, click the Application Builder icon.

    2. Select the application.

    3. Click the Utilities icon.

    4. From Page Specific Utilities, click Cross Page Utilities.

    5. Click Page Groups.

    6. Select a page group.

  3. Click Delete.

    A confirmation page appears.

  4. Confirm your request.

Locking and Unlocking a Page

You can prevent conflicts during application development by locking pages in your application. By locking a page, you prevent other developers from editing it.

Topics:

Determining If a Page Is Locked

A lock icon indicates whether a page is currently locked. If a page is unlocked, the icon appears as an open padlock. If the page is locked, the icon appears as a locked padlock. A lock icon appears on the Application home page and on the Page Definition.

To view the lock icon on the Application home page, click the View Detail icon. A detail view appears. The lock icon appears on the right side of the page.

Description of lock_ico.gif follows
Description of the illustration lock_ico.gif

The lock icon also appears on the Action Bar on the Page Definition. See "About the Developer Action Bar".

Locking a Page

You can lock pages from the Page Locks page, the Pages list, and from a Page Definition.

Locking a Page from the Page Locks Page

To lock a page from the Page Locks Page:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select an application.

  3. Click the Utilities icon.

  4. On the Page Specific Utilities list, click Cross Page Utilities.

  5. Click Page Locks.

  6. Select the appropriate pages and click Lock Checked.

  7. Enter a comment in the Comment field.

  8. Click Lock Page(s).

Locking a Page from the Detail View

To lock a page from the Detail view:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select an application.

  3. On the search bar, click the View Detail icon.

  4. Locate the page you want to lock and click the Lock icon.

  5. Enter a comment in the Comment field.

  6. Click Lock Page(s).

Locking a Page from the Page Definition

To lock a page from the Page Definition:

  1. Navigate to the appropriate Page Definition. See "Accessing the Page Definition".

  2. Click the Lock icon in the Developer Action bar. See "About the Developer Action Bar".

  3. Select the selected page and click Lock Checked.

  4. Enter a comment in the Comment field.

  5. Click Lock Page(s).

Tip:

You can also lock a page on the Page Definition, by clicking the Utilities button and then Lock.

Unlocking Pages

Only the developer who locked a page can unlock it. However, a developer with administrative privileges can unlock pages locked by other developers.

Unlocking Pages from the Page Locks Page

To unlock a page from the Page Locks page:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select an application.

  3. Click the Utilities icon.

  4. On the Page Specific Utilities list, click Cross Page Utilities.

  5. Click Page Locks.

  6. Select the appropriate pages.

  7. Click Unlock Checked.

Unlocking Pages from the from the Detail View

To unlock a page from the Detail view:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select an application.

  3. On the search bar, click the View Detail icon.

  4. In the Pages list, locate the page you want to unlock and click the Lock icon.

    The Edit Lock Comment page appears.

  5. Click Unlock.

Unlocking Pages from the Page Definition

To unlock pages from the Page Definition:

  1. Navigate to the appropriate Page Definition. See "Accessing the Page Definition".

  2. Click the Lock icon in the upper right corner above Shared Components.

    The Page Locks page appears.

  3. Select the page you want to unlock and click Unlock.

    Tip:

    You can also unlock a page on the Page Definition, by clicking the Utilities button and then Unlock.

Unlocking Pages As a Workspace Administrator

To unlock pages as a Workspace Administrator:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select an application.

  3. Click the Utilities icon.

  4. On the Page Specific Utilities list, click Cross Page Utilities.

  5. Click Page Locks.

  6. Click Lock Administration.

  7. Select the appropriate pages.

  8. Click Unlock Page(s).

Deleting a Page

Deleting a page deletes the corresponding tabs, breadcrumbs, and list entries. You can only delete pages that are locked or unlocked by you. See "Locking and Unlocking a Page".

Topics:

Deleting a Page from the Page Definition

To delete a page from the Page Definition:

  1. Navigate to the appropriate Page Definition. See "Accessing the Page Definition".

  2. Verify the page number.

  3. Click the Utilities button and then click Delete.

  4. Click Permanently Delete Page.

See Also:

"Editing a Page in Component View" for information about editing page attributes

Deleting a Page While Editing Page Attributes

To delete a page while editing page attributes:

  1. Navigate to the Page Definition. See "Accessing the Page Definition".

  2. To access the Edit Page:

    • Tree view - Under Page Rendering, double-click the page title at the top of the tree.

    • Component view - Under Page, click the Edit All icon.

    The Page Attributes page appears. Required values are marked with a red asterisk (*).

  3. Verify the page number and page name.

  4. Click Delete.

  5. Follow the on-screen instructions.

Deleting Multiple Pages

To delete multiple pages:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select an application.

  3. Click Utilities.

  4. From Page Specific Utilities, click Cross Page Utilities.

  5. Click Delete Multiple Pages.

  6. Select the pages to be deleted and click Delete Pages.

Deleting a Range of Pages

To delete a range of pages:

  1. On the Workspace home page, click the Application Builder icon.

  2. Select an application.

  3. Click Utilities.

  4. From Page Specific Utilities, click Cross Page Utilities.

  5. Click Delete Multiple Pages.

  6. Click the Delete Pages by Range tab.

  7. Enter the pages to be deleted and click Delete Pages.