| View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||
|---|---|---|---|---|---|---|---|---|---|
| 0000643 | v2.2 Release (Closed) | [All Projects] General | public | 2010-11-25 01:06 | 2010-12-19 13:18 | ||||
| Reporter | paul_rogers6 | ||||||||
| Assigned To | caseydk | ||||||||
| Priority | normal | Severity | minor | Reproducibility | always | ||||
| Status | closed | Resolution | fixed | ||||||
| Product Version | |||||||||
| Target Version | Fixed in Version | 2.2 | |||||||
| Summary | 0000643: When tasks are listed, if two tasks have the same start_date order may be incorrect. | ||||||||
| Description | If two tasks have the same task_start_date then the order which they appear in the project tasks list is not always correct. This is particularly obvious where one of the tasks is a milestone, eg: Name task_start_date task_end_date Order raised 23/11/2010 08:00 23/11/2010 08:00 (milestone) Preparation 23/11/2010 08:00 27/11/2010 17:00 In the above case the preparation activity often appears before the "order raised" activity. | ||||||||
| Additional Information | This is because the sql in modules/tasks/tasks.php only order on the task_start_date, thus: 311 if (!$project_id && !$task_id) { 312 $q->addOrder('p.project_id, task_start_date'); 313 } else { 314 $q->addOrder('task_start_date'); 315 } (line numbers for v2.1.0 shown) This should be changed as follows: 311 if (!$project_id && !$task_id) { 312 $q->addOrder('p.project_id, task_start_date, task_end_date'); 313 } else { 314 $q->addOrder('task_start_date, task_end_date'); 315 } An updated copy of the file is included (v2.1.0). | ||||||||
| Tags | No tags attached. | ||||||||
| Attached Files |
| ||||||||
 Relationships |
|
 Relationships |
| Notes |
|
|
caseydk (administrator) 2010-12-03 11:53 |
Patched as described in r1508, will be in the v2.2 release. |
|
caseydk (administrator) 2010-12-19 13:18 |
In v2.2 release. |
| Notes |
| Issue History |
|||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2010-11-25 01:06 | paul_rogers6 | New Issue | |
| 2010-11-25 01:06 | paul_rogers6 | File Added: tasks.php | |
| 2010-12-03 11:52 | caseydk | Project | v2.0 Release (Closed) => v2.2 Release (Closed) |
| 2010-12-03 11:53 | caseydk | Note Added: 0001389 | |
| 2010-12-03 11:53 | caseydk | Status | new => resolved |
| 2010-12-03 11:53 | caseydk | Resolution | open => fixed |
| 2010-12-03 11:53 | caseydk | Assigned To | => caseydk |
| 2010-12-19 13:18 | caseydk | Note Added: 0001452 | |
| 2010-12-19 13:18 | caseydk | Status | resolved => closed |
| 2010-12-19 13:18 | caseydk | Fixed in Version | => 2.2 |
| Issue History |