Databases Reference
In-Depth Information
add an Action Link to a custom URL target where the URL is set to:
f?p=4800:9001:&SESSION.::NO:9001:P9001 ID:#ID#
. If you run the page again you'll see something like
what's shown in Figure 4-11. Now click on a bar in the charts and you will be redirected to the page
where you can view and edit the feature you clicked. Notice the parameter used is
#ID#
and not the
actual column name you provided in the SQL.
Figure 4-11.
Feature Gantt example
To Do's
To Do's
are small pieces of work, or actions, you assign to your co-workers and want to track. As with
features, you can create a multilevel breakdown of To Do's. But if you really want to keep track of things,
creating a multilevel breakdown might not be the wisest thing to do, because if you have a lot of To Do's
defined, it can be rather difficult to keep oversight of them all. Also, since Team Development is not a
real planning tool (compared to Microsoft Project, for example), all the figures you enter, like dates and
estimated effort, are not accumulated to the higher level. So you cannot simply rely on those figures;
you'll need some additional reports to get closer to the real situation.
The Basics
The data model for the To Do part is shown in Figure 4-12. This gives you an idea of how the tables and
views are related and where the fields on the page in Figure 4-13 come from.
Figure 4-12.
Data model for To Do items
