Task list database table
From TaskDepender
(→Design) |
|||
| Line 9: | Line 9: | ||
== Design == | == Design == | ||
| − | The [[Tasks administration class|tasks administration]] must be filled with all the [[Task class|tasks]] in the current diagram | + | The [[Tasks administration class|tasks administration]] must be filled with all the [[Task class|tasks]] in the current diagram so that it can be used by the [[GUI]]. |
| − | + | This is done by creating a temporary table that holds all the tasks in the current container. | |
| + | This can be using <tt>CREATE AS</tt>. Additionally, this class also contains the <tt>IsContainer</tt> field that needs to be specified. This can be done by going through the [[Tasks database table|tasks table]] and the [[Deliverables database table|deliverables table]] and counting the elements that have the <tt>ContainerId</tt> equal to the task that is being added to the table. If this is greater than 0 then the task is a container. The query statement must take [[Clone|clones]] into account; those are contained in a task but are not to be counted as being a contained element. | ||
| + | |||
| + | The resulting query is given in the following section. | ||
== Implementation == | == Implementation == | ||
