MantisBT - v1.2 Release (Closed)
View Issue Details
0000143v1.2 Release (Closed)[All Projects] Generalpublic2009-04-27 22:062009-12-08 19:04
Assigned Tocaseydk 
PlatformOSOS Version
Product Version 
Target VersionFixed in Version1.2 
Summary0000143: Project % Complete Calculations
DescriptionOne 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 InformationTo 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;
TagsNo tags attached.
related to 0000086closed caseydk v2.0 Release (Closed) Percent Calculation with Subprojects 
related to 0000170closed caseydk v1.2 Release (Closed) Cache Worked/Scheduled/Project Hours 
child of 0000142closed caseydk Pending Requests System Performance Improvements 
Attached Files

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;

Issue History
2009-04-27 22:06caseydkNew Issue
2009-04-27 22:06caseydkRelationship addedchild of 0000142
2009-04-27 22:08caseydkRelationship addedrelated to 0000086
2009-05-31 21:28caseydkRelationship addedrelated to 0000170
2009-06-08 18:43caseydkProjectPending Requests => v1.1 Release (Closed)
2009-07-07 21:19caseydkPriorityhigh => low
2009-08-30 21:27caseydkStatusnew => assigned
2009-08-30 21:27caseydkAssigned To => caseydk
2009-09-08 22:54caseydkProjectv1.1 Release (Closed) => Pending Requests
2009-09-11 14:44caseydkProjectPending Requests => v1.2 Release (Closed)
2009-11-17 20:42caseydkPrioritylow => high
2009-11-25 20:30caseydkStatusassigned => resolved
2009-11-25 20:30caseydkResolutionopen => fixed
2009-11-25 20:30caseydkNote Added: 0000606
2009-12-08 19:04caseydkStatusresolved => closed
2009-12-08 19:04caseydkFixed in Version => 1.2