Create ADF Project Gantt Chart with Subtask and dependency from ADF Table

Home/ADF/Create ADF Project Gantt Chart with Subtask and dependency from ADF Table

Create ADF Project Gantt Chart with Subtask and dependency from ADF Table

In this section, we walk through how to create an ADF Project Gantt Chart from database tables. Here we are going to create a Gantt Chart with Subtask and Dependency. The final output will be like below

021017_0455_CreateADFGa1 Create ADF Project Gantt Chart with Subtask and dependency from ADF Table

If you are looking into creating ADF Gantt Chart programmatically then follow the below link

Create an ADF Gantt Chart programmatically

 

Pre-Requisites:

The following tables are required to create the ADF Project Gantt Chart. You can download the SQL file & the project at the bottom of the page.

TASK Table:

021017_0455_CreateADFGa2 Create ADF Project Gantt Chart with Subtask and dependency from ADF Table

  • The supported Type field values are Summary, Normal & Milestone. The values are case sensitive.
  • Check the Java class ProjectTask for additional fields

 

SUBTASK Table

 

021017_0455_CreateADFGa3 Create ADF Project Gantt Chart with Subtask and dependency from ADF Table

  • TaskID is the foreign key of the Task table

 

DEPENDENCY Table:

 

021017_0455_CreateADFGa4 Create ADF Project Gantt Chart with Subtask and dependency from ADF Table

  • TaskId is the foreign key of the Task table
  • The Type field supported values are fs, sf, ss, ff. The values are case-sensitive 

 

ADF Gantt Chart Example with SubTask & Dependency

1. Create an ADF Fusion Web Application

2. Create EO & VO objects for Task, Subtask & Dependency table

3. Create a JSF page under Web Content

4. Expand Data Controls, Drop the Task View inside the Form tag in the JSF page as shown below

 

021017_0455_CreateADFGa5 Create ADF Project Gantt Chart with Subtask and dependency from ADF Table

 

5. The following dialogue open. Select the Task tab, Configure the dropdowns as highlighted below

 

021017_0455_CreateADFGa6 Create ADF Project Gantt Chart with Subtask and dependency from ADF Table

 

5. Select the tab SubTask, Configure the columns as highlighted below

 

021017_0455_CreateADFGa7 Create ADF Project Gantt Chart with Subtask and dependency from ADF Table

 

6. Select the Dependent Tasks, Configure the drop downs as highlighted below

 

021017_0455_CreateADFGa8 Create ADF Project Gantt Chart with Subtask and dependency from ADF Table

 

7. The <dvt:ProjectGantt element configured on the JSF page. Input a Summary & Project Start/End time in the highlighted area. ADF Project Gantt chart display the bar between the dates

 

021017_0455_CreateADFGa9 Create ADF Project Gantt Chart with Subtask and dependency from ADF Table

 

8. Run the application will display the following output

 

021017_0455_CreateADFGa10 Create ADF Project Gantt Chart with Subtask and dependency from ADF Table

 

9. Expand a Task to see the SubTask

 

021017_0455_CreateADFGa11 Create ADF Project Gantt Chart with Subtask and dependency from ADF Table

 

Download the Project: ADF_GANTT_CHART_EXAMPLE

SQL File: ADF_GANTT_CHART_EXAMPLE_SQL

pgn Create ADF Project Gantt Chart with Subtask and dependency from ADF Table

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply 🙂
pgn Create ADF Project Gantt Chart with Subtask and dependency from ADF Table
Like us on Facebook.
Connect!