Details
-
Bug
-
Resolution: Fixed
-
Highest
-
5.2 (JIRA 4.1 Compatible), 5.2.3, 5.3 (JIRA 4.2 Compatible), 5.2.4, 5.2.1, 5.2.2
-
None
-
5.02
-
Description
Excel(Chart Data) exported from Version Statistic>Actions Menu>Excel(Chart Data) not correct as logged in JIRA.
The Issue ABC-123 have the following:
History changes
| Action | Old value | New Value | date |
|---|---|---|---|
| Time Spent | 2 hours [ 7200 ] | 24/Sep/10 4:25 PM | |
| Remaining Estimate | 2 hours [ 7200 ] | 24/Sep/10 4:25 PM | |
| Remaining Estimate | 2 hours [ 7200 ] | 4 hours [ 14400 ] | 24/Sep/10 4:25 PM |
| Time Spent | 2 hours [ 7200 ] | 0 minutes [ 0 ] | 24/Sep/10 4:26 PM |
| Remaining Estimate | 4 hours [ 14400 ] | 6 hours [ 21600 ] | 24/Sep/10 4:26 PM |
| Original Estimate | 6 hours [ 21600 ] | 4 hours [ 14400 ] | 24/Sep/10 4:26 PM |
| Remaining Estimate | 6 hours [ 21600 ] | 4 hours [ 14400 ] | 24/Sep/10 4:26 PM |
| Time Spent | 0 minutes [ 0 ] | 2 hours [ 7200 ] | 24/Sep/10 4:26 PM |
| Remaining Estimate | 4 hours [ 14400 ] | 2 hours [ 7200 ] | 24/Sep/10 4:26 PM |
| Remaining Estimate | 2 hours [ 7200 ] | 0 minutes [ 0 ] | 05/Oct/10 10:31 AM |
| Time Spent | 2 hours [ 7200 ] | 4 hours [ 14400 ] | 05/Oct/10 10:31 AM |
Work Log
| logged work - 24/Sep/10 2:26 PM - edited | Time Worked:2 hours |
| logged work - 05/Oct/10 8:30 AM | Time Worked:2 hours |
And below is the data from the chart excel data via cog icon>Excel(Chart data).
| Issue key | Issue type | Parent | Summary | Assignee | Status | Original estimate | 2-Aug | 3-Aug | ... | 28-Sep | ... | 6-Oct | 7-Oct | ... | 19-Oct | ... | 1-Nov | 2-Nov | 3-Nov | ... | 23-Nov |
| ABC-123 | Sub-task | ABC-100 | xxxxxxx | t901281 | Resolved | 4 | 4 | 4 | 4 | 8 | 8 | 8 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 |
The excel data seems doesn't reflect what is being logged in JIRA.
According to JIRA history, the last changes in the worklog will the 2 hours time spents at 05/Oct/10.
However according to excel data, there is not work /estimate time recored at 24-Sept and 05-Oct; apart from that time remaining increase to 8 hours. The data shows the first work logged at 7-Oct which is wrong.
And below is the data extract from the database worklog table.
23536, 33270, 'user1', '', , 'xxxxxx', '2010-09-24 16:26:42', 'user1', '2010-09-24 16:27:02', '2010-09-24 14:26:00', 7200
24161, 33270, 'user1', '', , 'xxxx.', '2010-10-05 10:31:22', 'user1', '2010-10-05 10:31:22', '2010-10-05 08:30:00', 7200
Attachments
Issue Links
- is duplicated by
-
-
- Closed
-