Week3.4 Lab

Improve To Dos
Introduction
In this lab, you will learn how to add additional columns to a report and improve a list of values.
Step 1 - Adding Columns to the Report.

In the Runtime environment navigate to To Dos and notice that the report includes the Task but
not the associated Project and Milestone. To retrieve these values in the report you need to utilize
an SQL which ties in the Projects and Milestones tables. This can be done using inner selects or
by joining multiple tables together. For simplicity you are going to implement inner select
statements.
1. From the runtime application, navigate to the To Dos report page, and then navigate to
Page Designer.
In the Developer Toolbar click Edit Page 9.
You should now be in Page Designer with Page 9: To Dos loaded.
2. You need to update the query defined for To Dos.
Within Page Designer, in the Rendering tree (left pane), click To Dos.
In the Property Editor (right pane), for Source > Type, select SQL Query.
{Note: The SQL Query will be populated. The SQL statement selects all of the columns
from the HOL_TO_DOS table.}
For Source > SQL Query, click the Code Editor icon.
In the Code Editor, enter the following:
Copyselect ID,
(select p.name
from hol_projects p, hol_tasks t
where p.id = t.project_id
and t.id = td.task_id
) project,
(select m.name
from hol_milestones m, hol_tasks t
where m.id = t.milestone_id
and t.id = td.task_id
) milestone,
TASK_ID,
ROW_VERSION,
TODO,
ASSINGEE,
DUE_DATE,
DETAILS,
CREATED,
CREATED_BY,
UPDATED,
UPDATED_BY
from HOL_TO_DOS td
In the Code Editor toolbar, click Validate. Click OK.
{Note: The two inner select statements connect the projects / milestones tables to the
tasks table, and the tasks table to the todos table.}
3. Run the application to ensure the new Project and Milestone columns display correctly.
In the Page Designer toolbar, click Save and Run.
4. The new project and milestone columns are placed as the last columns in the report,
however, they should be moved to be the first columns.
In the runtime environment, in the To Dos report menu, click Actions.
In the dropdown, select Columns.
5. In the Select Columns dialog, click Project.

Hold down the [Shift] key, and click Milestone.
In the options on the right of the dialog, click Top.
Click Apply.
6. You need to save the revised report layout so others will see the new and improved
column placement.
In the runtime environment, in the To Dos report menu, click Actions.

In the dropdown, select Report, and then click Save Report.
7. In the Save Report dialog, for Save (Only displayed for developers), select As Default
Report Settings.
8. In the Save Default Report dialog, click Apply.
{Note: You want to save the report as Primary so that it displayed as you see it now to
end users when they navigate to the page.}
Step 2 - Updating the Tasks LOV.

If you review the To Dos form page, by clicking an edit icon on the report, you will see that
Project and Milestone are not on the form page either. To simplify data entry, you will change
the Tasks select list to a Popup LOV and include the Project and Milestone.
This same LOV is used on the Links form page so we can reuse it there as well.
1. From the runtime environment, in the Developer Toolbar, click Application xxxxx.
2. From the application home page, click Shared Components.
3. From Shared Components, under Other Components, click List of Values.

4. From the List of Values page, click HOL_TASKS.NAME.
5. In the List of Values page, enter the following:
o Source > Source Type - click SQL Query
o Source > SQL Query - enter the following -
o Copyselect id
o , (select p.name from hol_projects p where p.id =

t.project_id) project
o , (select m.name from hol_milestones m where m.id

= t.milestone_id) milestone
o , name
o from hol_tasks t
o Column Mapping > Return - select ID
o Column Mapping > Display - select NAME
o Column Mapping > Default Sort - select NAME

To display the extra columns, click Select Columns
On the Select Additional Display Columns, performing the following actions:
o Move PROJECT (Varchar2) to the right pane

o Move MILESTONE (Varchar2) to the right pane
o Move NAME (Varchar2) to be below Milestone in the right pane
{Note: The ID column must be included in the list, however, it will be marked as Visible
= No so will not be displayed.}
Click Update.
In the List of Values toolbar, click Apply Changes.
6. On the To Do form page you will need to update the item type for Task.
From Shared Components, within the breadcrumbs, click Application xxxxx.

From the application home page, in the list of pages, click 10 - To Dos.
7. Within Page Designer, in the Rendering tree (left pane), click P10_TASK_ID.
In the Property Editor (right pane), for Identification > Type, select Popup LOV.
8. In the Page Designer toolbar, click Save.
9. Time to review the completed form page.
Navigate to the runtime environment tab or browser.

Navigate to To Dos and refresh the page.
Click the edit icon for a To Do.
For Task, click the down arrow to display the Task Popup LOV.
Enter in a search term and hit [Enter].
Summary
You now know how to enhance report and list of value queries to display related details.

Week3.4 Lab

Uploaded by

Copyright:

Available Formats

Week3.4 Lab

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Week3.4 Lab

Uploaded by

Copyright:

Available Formats

Improve To Dos

Step 1 - Adding Columns to the Report.

In the Developer Toolbar click Edit Page 9.

You should now be in Page Designer with Page 9: To Dos loaded.

2. You need to update the query defined for To Dos.

from hol_projects p, hol_tasks t

where p.id = t.project_id

and t.id = td.task_id

from hol_milestones m, hol_tasks t

where m.id = t.milestone_id

and t.id = td.task_id

In the Code Editor toolbar, click Validate. Click OK.

In the Page Designer toolbar, click Save and Run.

5. In the Select Columns dialog, click Project.

In the runtime environment, in the To Dos report menu, click Actions.

Step 2 - Updating the Tasks LOV.

2. From the application home page, click Shared Components.

3. From Shared Components, under Other Components, click List of Values.

5. In the List of Values page, enter the following:

o Source > Source Type - click SQL Query

o Source > SQL Query - enter the following -

o , (select p.name from hol_projects p where p.id =

o , (select m.name from hol_milestones m where m.id

o Column Mapping > Return - select ID

o Column Mapping > Display - select NAME

o Column Mapping > Default Sort - select NAME

On the Select Additional Display Columns, performing the following actions:

o Move PROJECT (Varchar2) to the right pane

In the List of Values toolbar, click Apply Changes.

From Shared Components, within the breadcrumbs, click Application xxxxx.

8. In the Page Designer toolbar, click Save.

9. Time to review the completed form page.

Navigate to the runtime environment tab or browser.

You might also like