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

E11947-03
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
PDF · Mobi · ePub

Managing Pages in an 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 in this section include:

About Creating Pages

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:
    • SQL 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: "Creating Reports" and "Implementing Web Services"

    Chart Enables you to create three types of graphical charts: HTML, Scalable Vector Graphics (SVG), and Flash.

    See Also: "Creating Charts"

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

    See Also: "Creating Forms"

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

    See Also: "Creating Calendars"

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

    See Also: "Creating Trees"

    Login Page Creates a login page.

    See Also: "Building a Login Page"

    Access Control Creates a page containing a 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"

    Page Zero A page zero that functions as a master page. The Application Express engine renders all components you add to page zero on every page within your application. You can further control whether the Application Express engine renders a component or runs a computation, validation, or process by defining conditions.

    See Also: "Displaying Components on Every Page of an Application"


  5. Follow the on-screen instructions.

Creating a Page from the Page Definition

To create a page while viewing a Page Definition:

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

  2. Click the Create button at the top of the page.

  3. Select the type of page you want to create:

    • New Page

    • Region on this page

    • Page control on this page

    • Shared Control

    See "About Create Page Types".

  4. Follow the on-screen instructions.

About Create Page Types

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

Table 6-1 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

  • Help Text

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

Page control on this page

Page controls:

Shared control

Shared component options:


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 Definition page.

See Also:

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

To create a page from the Developer toolbar:

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

  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.

Copying a 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. Click the Copy button.

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

    • Page in this application

    • Page in another application

  4. Follow the on-screen instructions.

Running a Page or Application

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 in this section include:

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 green 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 Details 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 Details 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 Page icon in the upper right corner 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 in this section include:

Viewing Page Groups

The section describes different ways to view page groups.

Accessing the Page Groups Page

To access the Page Groups page:

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

  2. Select the application.

  3. On the Tasks List on the right side of the page, click Page Groups.

    The Page Groups page appears.

    Use the Navigation bar at the top of the page to search for a page group by name or change the page display. You can change the default display by making a selection from View list. Available options include:

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

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

  4. To view the pages associated with a group, click Report Page Groups on the Tasks list.

    Note:

    The Tasks list only appears if groups currently exist.
  5. To edit the group name and description, click the group name.

Viewing Page Groups from the Application Home Page

To view page groups from the Application home page:

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

  2. On the Application Builder home page, select an application.

  3. From the View list, select by Group and click Go.

    Any defined groups appear. Pages not associated with a group are filed in the Unassigned folder.

    Description of groups.gif follows
    Description of the illustration groups.gif

  4. To view the pages within a group, click the group name.

Viewing Page Groups from the Page Definition

To view page groups from the Page Definition:

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

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

  3. Make a selection from the Tasks list on the right side of the page.

Creating a Page Group

To create a page group:

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

  2. Select an application.

  3. On the Tasks List on the right side of the page, click Page Groups.

  4. On the Page Groups page, click Create.

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

Accessing 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 an application.

  3. On the Tasks List on the right side of the page, click Page Groups.

    Page Groups page appears.

  4. Select a page group.

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

  6. 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 an application.

  3. On the Tasks List on the right side of the page, click Page Groups.

  4. On the Tasks list, click Manage Unassigned.

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

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

  6. 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 an application.

  3. On the Tasks List on the right side of the page, click Page Groups.

  4. On the Tasks list, click Manage Assignments.

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

  5. From the Group list, select a group and click Go.

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

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

Removing a Page from a Page Group

To remove a page to a page group:

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

  2. Select an application.

  3. On the Tasks List on the right side of the page, click Page Groups.

  4. On the Tasks list, click Manage Assignments.

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

  5. From the Group list, select a group and click Go.

  6. Under Name, locate the Group list and select - Unassign -.

  7. Select the page to be removed.

  8. Click Apply Changes.

Deleting a Page Group

To remove a page group:

  1. Remove all pages from the group to be deleted. See "Removing a Page from a Page Group".

  2. Access the Page Group page. See "Accessing a Page Group Definition".

  3. Click Delete.

    A confirmation page appears.

  4. Confirm your request.

Viewing the Pages by Page Group Report

To view pages by page group:

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

  2. Select an application.

  3. On the Tasks List on the right side of the page, click Page Groups.

  4. On the Tasks list, click Report Page Groups.

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

  5. To view a page group, make a selection from the Group list and click Go.

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 in this section include:

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, select Details from the View list. A list of pages appears. The lock icon appears under the Lock column.

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 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. On the Tasks List on the right side of the page, click Page Locks.

    The Page Locks page appears.

  4. Select the appropriate pages and click Lock Checked.

  5. Enter a comment in the Comment field.

  6. Click Lock Page(s).

Locking a Page from the Details View

To lock a page from the Details view:

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

  2. Select an application.

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

  4. In the Pages list, 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 a Page Definition".

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

  3. Select the selected page and click Lock Checked.

  4. Enter a comment in the Comment field.

  5. Click Lock Page(s).

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 the application.

  3. On the Tasks List on the right side of the page, click Page Locks.

    The Page Locks page appears.

  4. Select the appropriate pages.

  5. Click UnLock Checked.

Unlocking Pages from the from the Details View

To unlock a page from the Details view:

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

  2. Select an application.

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

  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 a 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 Checked.

Accessing Alternative Locked Pages Views

You can access a number of different views of Locked Pages on the Locked Pages page.

To access different views of locked pages:

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

  2. Select the application.

  3. On the Tasks List on the right side of the page, click Page Locks.

  4. On the Tasks list, click one of the following:

    • Show Locked Pages displays only locked pages within the current application.

    • Show All Pages displays all pages within the current application.

    • Show Unlocked Pages displays only unlocked pages within the current application.

    • Administer Locks enables an administrator to unlock any pages locked by a developer.

Deleting a Page

You can delete a page from the Page Definition or while editing page attributes.

Topics in this section include:

Deleting a Page from the Page Definition

To delete a page from the Page Definition:

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

  2. Verify the page name.

  3. Click the Delete button at the top of the page.

  4. Follow the on-screen instructions.

See Also:

"Editing a Page Definition" 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 a Page Definition".

  2. Under Page Rendering, locate the Page section.

  3. Click the Edit page attributes icon to link to Page Attributes page. This icon resembles a small page with a pencil on top of it.

    Description of pg_def_edit_pg_att.gif follows
    Description of the illustration pg_def_edit_pg_att.gif

    The Edit Page appears.

  4. Verify the page number and page name.

  5. Click Delete.

  6. Follow the on-screen instructions.