All Projects | wbTeamPro | wbTimeLog |
Anonymous | Login | Signup for a new account | 2024-05-07 23:01 EST |
Dashboard | Features | Bugs | Report Issue | My View | View Issues | Change Log | Roadmap | My Account |
View Issue Details [ Jump to Notes ] [ 1 Vote ] | [ Issue History ] [ Print ] | ||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | ||||
0010255 | wbTeamPro | [All Projects] Features | public | 2017-01-30 09:31 | 2015-01-25 00:00 | ||||
Reporter | webuddha | ||||||||
Assigned To | webuddha | ||||||||
Priority | normal | Severity | minor | Reproducibility | always | ||||
Status | Implemented | Resolution | added | ||||||
Platform | OS | OS Version | |||||||
Product Version | |||||||||
Target Version | Applied to Version | v3.0.14 | |||||||
Summary | 0010255: Action Listing by Calculated Priority | ||||||||
Description | Improve the action list sorting to provide better priority sorting using a weight value, priority value, due date, and percentage completed. | ||||||||
Tags | action, list view | ||||||||
Attached Files |
Notes | |
(0010050) webuddha (administrator) 2013-06-19 10:47 edited on: 2013-06-19 10:53 |
This value could be called the "Score" representing something like this: Score = (Date > Due Date ? (Date - Due Date) : exp(Due Date - Date)) * (Priority) * (Weight) * ((100 - Percentage Complete)/100) |
(0010051) webuddha (administrator) 2013-06-22 10:48 edited on: 2013-06-24 13:58 |
The total score is a value from 0..100, calculated based on the following weights. 70% = DateScore 10% = ActivityScore 10% = PriorityScore 10% = CompleteScore IF(`action`.`action_complete`=100 ,0 ,( ((IF( `action`.`date_finish` = CURDATE() , 0.25 , IF( `action`.`date_finish` > CURDATE() , IF( (DATEDIFF(`action`.`date_finish`,CURDATE())>365), 0, 0.25 - ((DATEDIFF(`action`.`date_finish`,CURDATE())/365)*.25) ) , IF( (DATEDIFF(CURDATE(),`action`.`date_finish`)>90), 1, 0.25 + ((DATEDIFF(CURDATE(),`action`.`date_finish`)/90)*.75) ) ) )) * 70) + ((IF( (DATEDIFF(NOW(),`action`.`date_activity`)>90) , 1 , IF( `action`.`date_activity`='0000-00-00 00:00:00' , IF( (DATEDIFF(NOW(),`action`.`date_modified`)>90) , 1 , (DATEDIFF(NOW(),`action`.`date_modified`)/90) ) , (DATEDIFF(NOW(),`action`.`date_activity`)/90) ) )) * 10) + ((((`action`.`action_priority` - 1) / 2)) * 10) + ((IF( `action`.`date_finish` <= CURDATE() , 1 , IF( ((DATEDIFF(`action`.`date_finish`,CURDATE()) / (DATEDIFF(`action`.`date_finish`,`action`.`date_start`)+1)) > (100 - `action`.`action_complete`)) , ( (100 - `action`.`action_complete`) / (DATEDIFF(`action`.`date_finish`,CURDATE()) / (DATEDIFF(`action`.`date_finish`,`action`.`date_start`)+1)) ) , 0 ) )) * 10) ) ) AS `calc_actionScore` |
Issue History | |||
Date Modified | Username | Field | Change |
2013-06-19 10:41 | webuddha | New Issue | |
2013-06-19 10:41 | webuddha | ||
2013-06-19 10:41 | webuddha | Tag Attached: action | |
2013-06-19 10:41 | webuddha | Tag Attached: list view | |
2013-06-19 10:47 | webuddha | Note Added: 0010050 | |
2013-06-19 10:53 | webuddha | Note Edited: 0010050 | View Revisions |
2013-06-22 10:48 | webuddha | Note Added: 0010051 | |
2013-06-22 10:48 | webuddha | Assigned To | => webuddha |
2013-06-22 10:48 | webuddha | Status | New => In Progress |
2013-06-24 13:58 | webuddha | Note Edited: 0010051 | View Revisions |
2013-06-24 13:59 | webuddha | Status | In Progress => Implemented |
2013-06-24 13:59 | webuddha | Applied to Version | => v3.0.14 |
2013-06-24 13:59 | webuddha | Resolution | open => added |
Dashboard | Features | Bugs | Report Issue | My View | View Issues | Change Log | Roadmap | My Account |
Copyright © 2000 - 2024 MantisBT Team |