1/15

Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 About Oracle Application Express

2 Before You Begin

3 Populating Your Workspace

• 3.1 Setting Up Your Workspace
• 3.2 Importing the Sample Tables
• 3.3 Importing the Sample Data
• 3.4 Populating the Tables with the Data
• 3.5 Reviewing Output with Object Browser

4 Creating the Initial Application

• 4.1 Creating a New Application Using the Create Application Wizard
• 4.2 Creating a Projects Page Using the Create Page Wizard
• 4.3 Creating a Calendar Using the Create Page Wizard
• 4.4 About Page Designer
• 4.5 Running the Application for the First Time

5 Developing the Home Page

• 5.1 Navigating to Page Designer from the Application Runtime
• 5.2 Adding a Task Overview Chart to the Home Page
• 5.3 Editing a Chart Region with the Property Editor
• 5.4 Defining the SQL Query of a Chart
• 5.5 Adding a Report of Outstanding Tasks to the Home Page
• 5.6 Changing Region Appearance Using the Developer Toolbar
• 5.7 Adding Icons to the Home Page Sidebar

6 Developing the Team Member Pages

• 6.1 Editing the SQL Query of an Interactive Report
• 6.2 Changing Which Columns Display in an Interactive Report in the Runtime
• 6.3 Moving Buttons to a Different Region
• 6.4 Enabling Stretch Form Fields for a Modal Dialog
• 6.5 Updating Form Fields to and Textarea
• 6.6 Creating an Expandable Sub Region
• 6.7 Restricting User Access with the Display Only Item Type

7 Developing the Projects Pages

• 7.1 Updating the SQL Query and Displayed Columns
• 7.2 Adding Names to the Project Lead Column with a Shared LOV
• 7.3 Updating the Appearance of the Projects Report Page
• 7.4 Customizing the Projects Report Columns
• 7.5 Changing the Project Form Appearance with Live Template Options
• 7.6 Updating the Project Form in Page Designer
• 7.7 Creating a Static LOV of Statuses
• 7.8 Creating a Dynamic Action
• 7.9 Adding a Validation for the Completed Date
• 7.10 Copying a Sub Region to a Different Page

8 Developing the Maintain Project Form Regions

• 8.1 Updating the Milestones Interactive Grid
• 8.2 Creating the Tasks Detail Region
• 8.3 Updating the Columns in the Tasks Region
• 8.4 Adding a Region Display Selector
• 8.5 Improving the Default Milestones Report in the Runtime
• 8.6 Improving the Default Tasks Report in the Runtime

9 Developing the Tasks Master Detail-Detail Regions

• 9.1 Creating the To-Dos Sub Region
• 9.2 Linking the To-Dos Sub Region
• 9.3 Improving the To-Dos Columns
• 9.4 Creating the Links Sub Region
• 9.5 Linking the Links Sub Region
• 9.6 Improving the Links Columns
• 9.7 Adding a Dynamic Action to Enable Columns for Link Type
• 9.8 Adding Opposite Actions to Dynamic Actions
• 9.9 Improving the To-Dos Interactive Grid in the Runtime
• 9.10 Improving the Links Interactive Grid in the Runtime

10 Developing the Calendar Page

• 10.1 Hiding the Header and Border of the Calendar in the Runtime
• 10.2 Enabling Drag and Drop of Individual Projects
• 10.3 Adding Links to the Calendar Page

A Importing an Application into a Workspace

Index