Adding Additional Components to your Existing Application

Perform the Manipulating Database Objects Using Application Express 3.2 tutorial.

Perform the Creating and Running an Application Using Application Express 3.2 tutorial.

Click Create Page > in the Project Tasks Application home page.

Select the Chart Page Type and click Next >.

Select the Flash Chart radio button and click Next >.

Enter the page name as Tasks per Project Chart, accept the other default values, and click Next >.

Select the Do not use tabs option and click Next >.

Select 2D Pie as the Chart Type, enter Tasks per Project as the Chart Title and click the Update button to refresh the chart preview.

Make sure the Show Hints, Show Labels, and the Show Labels check boxes are selected.

Click Next >.

Copy and paste the following query into the query field. Click Next >.

select null link,
       p.project label,
       t.task_count value
  from (select project_id,
               count(*) task_count
          from obe_tasks
         group by project_id) t,
       obe_projects p
 where t.project_id = p.project_id

Click Finish to create the chart.

The flash chart has been created. Click the Run Page icon to view the flash chart.

The flash chart shows the number of tasks per project. The first number for each slice of pie is the project and the second number is the number of tasks. Click the Application <n> link in the developer tool bar.

Click Create Page > in the Project Tasks Application home page.

Select the Calendar Page Type and click Next >.

Select the Easy Calendar radio button and click Next >.

Enter Project Tasks Calendar for the Page Name and Region Name. Then, click Next >.

Select the Do not use tabs option and click Next >.

Select OBE_PROJECTS for the Table / View Name and click Next > .

Ensure that PROJECT_DEADLINE is selected for the Date Column and PROJECT is select for the Display Column. Then click Next >.

Click Finish to create the calendar.

The calendar has been created. Before you run the page, you need to edit some settings. Click the Edit Page icon.

Click the Modern Blue link in the Theme region.

Select the Component Defaults tab.

Make sure that Calendaris selected from the drop-down list for Calendar. Click Apply Changes.

Click the Run Page icon to view the calendar.

The calendar shows the projects on the date due.

Note: To view projects on the date due, you should have entered project deadline dates in the OBE_PROJECTS table. You modify data in steps 8 and 9 of Modifying a Table section in the Manipulating Database Objects using Oracle Application Express 3.2 tutoriall.

You can also view the calendar in daily or weekly mode. Click Weekly.

The Weekly calendar mode is displayed. You can advance to next week. Click Next.

You can create a button to this calendar from the Projects report. Scroll down to the bottom of the weekly calendar and click the Application <n> link in the developer tool bar.

Click the Projects page.

In the buttons area, Click the Create () icon. Note: If you don't see the Buttons area, click the Show All icon.

Select the second Projects 1 (10) region and click Next >.

Select Create a button in a region position and click Next >.

Enter View Calendar for the Button Name and click Next >.

Accept the defaults and click Next >.

Accept the defaults and click Next >.

Click the up area to select a page to branch to.

Select Project Tasks Calendar.

Click Create Button.

The button gets created.

Check the text next to View Calendar in the Buttons region. It should say Redirect to page 5. If it says Submit as View_Calendar, click the View Calendar link.

Select the URL Redirect tab.

For Target is a, select Page in this Application. To select the page, click the up button and select Project Tasks Calendar. Click Appy Changes.

Click Run to view the Report with the button.

Click View Calendar.

The calendar is displayed. Click the Application <n> link in the developer tool bar.

Click the down arrow next to Shared Components > User Interface > Themes.

To create a new theme, click Create.

Accept the default From the Repository and click Next >.

From the Theme options, select the Theme 14 option. Click Next >.

Click Create.

To switch to the Modern theme, click Switch Theme.

For Switch to Theme, make sure 14. Modern is selected. Click Next >.

Notice that the page displays the compatibility between the two themes. This utility checks whether there is a template in the new theme to replace each of the templates in the current theme. The check marks in the Status column indicate that the templates are compatible. Under To Template Class, select Report List for Region template type. Click Next >.

To confirm the theme switch, click Switch Theme.

To see the new theme, click the Run Page icon ( ) at the top right of the page.

Notice that the entire appearance of your application has changed. The color scheme has changed. Click the Application <n> link from the developer tool bar.

Select the down arrow next to Shared Components and select Application>Definition.

Click the Logo tab.

Select Text for the Logo Type. Enter Project Tracker for Logo and Black Text for Logo Attributes. Then click Apply Changes.

To see the logo, click the Run Page icon ( ) at the top right of the page.

The text is displayed. Click the Application <n> link from the developer tool bar.

Click the Home page.

Select the Regions () icon.

In the regions area, click the List link.

Click Create List Entry >.

Enter 20 for the Sequence, Manage Projects and Tasks in the List Entry Label field. Ensure that Page in this Application is selected in the Target type and then click the up arrow for the Page.

Select 2 Projects.

Select the reset pagination for this page option and click Create and Create Another. By selecting to reset pagination, the link always displays the first set of records when the user clicks the link regardless of which set they were viewing the last time they accessed the page.

Enter 30 for the Sequence, View Tasks per Project Chart in the List Entry Label field. Ensure that Page in this Application is selected in the Target type and then click the up arrow for the Page.

Select 4 Tasks per Project Chart.

Select the reset pagination for this page option and click Create.

Your entry was added to the list. Click the Run Page 1 ( ) icon.

Notice the new two entries. Click Manage Projects and Tasks.

The Projects report is displayed. Click the Home link.

Click View Tasks per Project Chart. The page is listed. Click the Application <n> link in the developer tool bar.