View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||
---|---|---|---|---|---|---|---|---|---|
0000143 | v1.2 Release (Closed) | [All Projects] General | public | 2009-04-27 22:06 | 2009-12-08 19:04 | ||||
Reporter | caseydk | ||||||||
Assigned To | caseydk | ||||||||
Priority | high | Severity | feature | Reproducibility | always | ||||
Status | closed | Resolution | fixed | ||||||
Product Version | |||||||||
Target Version | Fixed in Version | 1.2 | |||||||
Summary | 0000143: Project % Complete Calculations | ||||||||
Description | One of the single most important values that is calculated constantly is a Project's percent complete. While it's trivial for small projects, for larger projects - or on project list screens - it gets to be a non-trivial and often horribly painful calculation. Since we already have "project_percent_complete" on the Projects table, we should be able to calculate and cache it. | ||||||||
Additional Information | To ensure accurate information, this should value should be recalculated when - we update any of that Project's Tasks have their duration or percent complete updated; - we update any child Project of the current Project; | ||||||||
Tags | No tags attached. | ||||||||
Attached Files |
|
![]() |
|||||||||||||||||||
|
![]() |
|
caseydk (administrator) 2009-11-25 20:30 |
Updated to pre-calculate the project_percent_complete value instead of calculating it on the fly for every page load in r805; Also added a migration to backfill all old project_percent_complete values; |
![]() |
|||
Date Modified | Username | Field | Change |
---|---|---|---|
2009-04-27 22:06 | caseydk | New Issue | |
2009-04-27 22:06 | caseydk | Relationship added | child of 0000142 |
2009-04-27 22:08 | caseydk | Relationship added | related to 0000086 |
2009-05-31 21:28 | caseydk | Relationship added | related to 0000170 |
2009-06-08 18:43 | caseydk | Project | Pending Requests => v1.1 Release (Closed) |
2009-07-07 21:19 | caseydk | Priority | high => low |
2009-08-30 21:27 | caseydk | Status | new => assigned |
2009-08-30 21:27 | caseydk | Assigned To | => caseydk |
2009-09-08 22:54 | caseydk | Project | v1.1 Release (Closed) => Pending Requests |
2009-09-11 14:44 | caseydk | Project | Pending Requests => v1.2 Release (Closed) |
2009-11-17 20:42 | caseydk | Priority | low => high |
2009-11-25 20:30 | caseydk | Status | assigned => resolved |
2009-11-25 20:30 | caseydk | Resolution | open => fixed |
2009-11-25 20:30 | caseydk | Note Added: 0000606 | |
2009-12-08 19:04 | caseydk | Status | resolved => closed |
2009-12-08 19:04 | caseydk | Fixed in Version | => 1.2 |