014 Building an Application part 08 Interactive Grid [Oracle Apex 5 1 Tu...

Oracle Apex 5 1 Tutorial

Building an Application part 08 Interactive Grid (IG)

Oracle Documentation:

https://docs.oracle.com/database/apex-5.1/AETUT/AETUT.pdf

My Blog:

https://abuelenain.blogspot.com/

Scripts:
http://www.mediafire.com/file/vcdfwvxfi545juf/apex51-demo-basic-3760632.zip

SQL query:

select ID

, NAME

, DESCRIPTION

, PROJECT_LEAD

, COMPLETED_DATE

, STATUS

, CREATED

, CREATED_BY

, UPDATED

, UPDATED_BY

, (select count('x')

from demo_milestones m

where m.project_id =
p.id

) milestones

, (select count('x')

from demo_tasks t

where t.project_id =
p.id

) tasks

from DEMO_PROJECTS p

·
Developing the Projects Pages

·
Updating the SQL Query and
Displayed Columns

·
Adding Names to the Project Lead
Column with a Shared LOV

·
Updating the Appearance of the
Projects Report Page

·
Customizing the Projects Report
Columns

Comments

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, clic...

Oracle APEX - Tabular form datepicker month and year selector

My Resume (Hesham Abu Elenain)

https://apex.oracle.com/pls/apex/sharko/r/h-apex-cv/home Thanks, @joelkallman @alhadara your support and motivation. My CV. https://t.co/87uW3O9CLH #orclapex #lowcode pic.twitter.com/lwJZ5ztYuC — Hesham (H-ā'pěks) (@habuelenain) July 6, 2020

Hesham Abu Elenain (H-ā'pěks)

Search This Blog