016 Building an Application part 10 Master 2Details IG [Oracle Apex 5.1 Tutorial]

Developing the Maintain Project Form Regions

Updating the Milestones Interactive Grid

Begin by updating the second interactive grid on page 5 which queries the DEMO_MILESTONES table .

To navigate to the Maintain Project form:

1.   From the Application home page, click 5 - Maintain Project .

To rename the second Maintain Project region (the name was inherited from a copy procedure in an earlier lesson):

2.   Scroll to the bottom of the Rendering tree or Layout tab, and click the Maintain Project sub region (note the italicized name).

3.   In the Property Editor:

a.   Identification: Title - enter Milestones

To change how the columns display:

1.   In the Rendering tree under Milestones, expand the Columns folder.

2.   Select the ID column.

3.   In the Property Editor:

a.   Identification: Type - select Hidden

4.   In the Rendering tree, click the Created column to both select it and deselect the ID column. Press and hold the Ctrl key and to select the following columns:

•           Created

•           Created By

•           Updated

Updated By

8.   In the Property Editor:

a.  
Identification: Type - select Display Only

8.2 Creating the Tasks Detail Region

Add a new interactive grid from the Gallery to query the DEMO_TASKS table and configure it to display as a smaller detail region.

To add an interactive grid region from the Gallery:

1.   In the Gallery pane located below the Layout pane, click the Regions tab.

2.   Right-click Interactive Grid, select Add To, select Content Body, select Milestones, and select After.

A new region appears in the Layout pane under the Milestones region.

3.   In the Property Editor:

a.   Identification: Title - enter Tasks

b.   Source: SQL Query - enter select * from demo_tasks where project_id = :P5_ID

Creating the Tasks Detail Region

a.   Source: Page Items to Submit - select P5_ID

b.   Layout: Start New Row - select Yes

c.   Appearance: Template - select Standard

d.   Server-side Condition: Type - select Item is NOT NULL

e.   Server-side Condition: Item - select P5_ROWID

Interactive grids are read-only by default, so you must configure the interactive grid to be editable.

To make an interactive grid editable:

4.   In the Rendering tree, under Tasks, select the Attributes folder.

5.   In the Property Editor:

a.   Edit: Enabled - select Yes

b.   Toolbar: Buttons - deselect Save

You must hide the ID and PROJECT_ID columns from view because they are not useful, but you must also perform an additional configuration on each to prepare them for a later step.

To clean up the Tasks region:

6.   In the Rendering tree, under Tasks, expand the Columns folder, and select the ID column.

7.   In the Property Editor:

a.   Identification: Type - select Hidden

b.   Source: Primary Key - select Yes

8.   In the Rendering tree, select the PROJECT_ID column.

9.   In the Property Editor:

a.   Default: Type - select Item

b.   Default: Item - select P5_ID

To  Continue....
Oracle Apex Documentation