I created simple report, that shows transitions of stories between
sprints. Maybe someone finds it useful. It can be extended to support
owner changes too:
select t_s.id, t_s.summary, CONCAT(ifnull(if(t_c.oldvalue!='',
t_c.oldvalue, 'none'), 'none'),' -> ',t_c.newvalue) AS
'sprint_change', tc_s.value AS 'current_sprint'
from ticket t_s
join ticket_custom tc_s on t_s.id = tc_s.ticket
join ticket_change t_c on t_s.id = t_c.ticket
where tc_s.name='sprint'
and t_s.type = 'story'
and t_c.field = 'sprint'
It displays:
+------
+-----------------------------------------------------------------
+----------------------------+----------------+
| id | summary | sprint_change | current_sprint |
+------
+-----------------------------------------------------------------
+----------------------------+----------------+
| 14 | summary1 | S1 -> S2 | S3 |
| 18 | summary2 | S1 -> S2 | S2 |
| 66 | summary3 | none -> S3 | S3 |
| 14 | summary4 | S2 -> S3 | S3 |
| 54 | summary5 | none -> S3 | S3 |
+------
+-----------------------------------------------------------------
+----------------------------+----------------+
Problem is that each change in ticket_change table is in its own row,
so including other changes ('owner',...) is trivial. It seems that
changes in db structure are not so trivial from existing reports
perspective of existing users so I guess this will be the only
possible approach in the long run if new tables will not be added.
On 18 avg., 18:02, tex <[email protected]> wrote:
> Hello.
>
> I have entered two history sprints in agilo:
> S1 from 26.6.09 - 10.7.09
> S2 from 14.7.09 - 31.7.09
>
> When S1 was over, two stories were not finished (some tasks were done
> and some not) and both stories moved to S2, where one was successfully
> finished and the other moved to S3: 4.8.09 - 21.8.09. What I would
> like to have is a good history overview about such events (some
> ideas):
>
> 1. Report #1: would show list of stories, that were moved from one
> sprint to another, together with their owners in each sprint, so I
> would know, which members in the team are failing to close stories:
> query: show me all stories Sj that were moved from one sprint to
> another and for each such sprint SPij show me user Uij that was owner
> for story
>
> 2. Report #2 would show me state of the story and its tasks on the end
> of the sprints, where they were active e.g.:
> query: show me all stories Sj that were moved from one sprint to
> another and for each such sprint SPij show me user Uij that was owner
> for story and also states of all tasks (finished, not finished) at the
> end of each sprint
>
> Report for story1:
> active in sprints: S1->S2->S3
> S1 (owner1):
> finished tasks #1(owner2), #4(owner3), #5 (owner1)
> not finished tasks #3(owner2), #6(owner7)
> S2 (owner1):
> finished tasks #1(owner2), #4(owner3), #5 (owner1), #3 (owner2)
> not finished tasks: #6(owner7)
> S3 (owner4):
> finished tasks #1(owner2), #4(owner3), #5 (owner1), #3 (owner2), #4
> (owner4)
>
> Does someone use something similar for history overview?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Agilo for Scrum" group. This group is moderated by agile42 GmbH
http://www.agile42.com and is focused in supporting Agilo for Scrum users.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/agilo?hl=en
-~----------~----~----~----~------~----~------~--~---
