Databases Reference
In-Depth Information
3.
Select the Columns you want to display. You have to select the Control Break
column as well or the break won't work.
4.
Compute the “Remaining” by entering a computation like BA * (100-BG),
where BA refers to the Effort and BG to the Status Percent.
5.
Aggregate the Effort—and maybe the Remaining as well.
Extending the Features Functionality
Now that you've entered some project information it would be nice to see this information in a way
you're used to when running projects: in a Gantt chart.
Create a new Chart Page in your Team Development Enhancement application, pick a Project Gantt
chart as the type to display, set the other settings as you like them, and enter this SQL query:
SELECT NULL link
, FEATURE NAME task name
, FEATURE ID task id
, PARENT FEATURE ID parent id
, NVL(START DATE,SYSDATE) actual start
, NVL(DUE DATE,SYSDATE) actual end
, FEATURE STATUS progress
FROM APEX TEAM FEATURES
START WITH PARENT FEATURE ID IS NULL
CONNECT BY PRIOR FEATURE ID = PARENT FEATURE ID
With the data presented in Figure 4-9, you'll get a Gantt chart when you run the page. You'll notice
that the start and end dates of the parent features don't match the dates of the subfeatures. You can
solve that by including the calculation of those dates in the SQL using analytic functions. Later in the
chapter, you'll learn how to let Anychart do the calculation, when you'll generate the XML used by the
Chart by yourself.
To enable the collapse functionality in this Anychart Gantt, you have to set the Show Datagrid
property to Yes and disable all Include on Datagrid items, as shown in Figure 4-10.
Figure 4-10.
Feature Gantt settings
Now, let's create a link from the Gantt chart back into Team Development. Notice we didn't include
a link in the SQL query, because that solution doesn't work anymore. Instead, go to the Chart Series and
