Hi Joe!
On 06/05/11 18.57, HP Joe wrote:
How can we create a report which shows the
user stories linked to Requirements,
With our recent installation of
Trac 0.12.2
Agilo 0.9.3
We are eagerly trying to adopt this in several agile projects.
With Agilo / Trac you have a pretty flexible way to create reports,
as you can specify your own queries using the TracQuery language.
You can find more info on Trac reports here:
http://your_agilo_instance_url/wiki/TracReports
and here you can find a detailed explanation of the language:
http://your_agilo_instance_url/wiki/TracQuery#QueryLanguage
To create a new report:
1. login as TRAC_ADMIN or REPORT_ADMIN
2. go to http://your_agilo_instance_url/report
3. Click Create New Report
4. Fill in title, description and query
5. Save the report
6. Access the report you just created on the left bar
For what concerns your case, you might use the following query:
SELECT 'Use Case #'||usecase.id||': '||usecase.summary as __group__,
story.id AS ticket, story.status AS status, story.summary AS summary,
story.owner AS owner, story.time AS created, sprint.value AS sprint,
(CASE story.status
WHEN 'new' THEN 1
WHEN 'assigned' THEN 2
WHEN 'accepted' THEN 2
WHEN 'closed' THEN 5
ELSE 3
END) AS __color__
FROM ticket story
LEFT JOIN agilo_link link ON story.id=link.dest
LEFT JOIN ticket usecase ON link.src=usecase.id
LEFT JOIN ticket_custom sprint ON sprint.ticket=story.id AND
sprint.name='sprint'
WHERE usecase.id NOT NULL
AND usecase.milestone=$MILESTONE
AND usecase.type='requirement'
ORDER BY usecase.id
This requires that you hand in a milestone name in the URL, e.g.
appending ?MILESTONE=foo at the end of the URL that you use
for accessing the report
Alternatively, you can have a report that includes all milestones,
and have the milestone as a column of the report. In this way
you don't have to provide a parameter in the URL. A query for that
could be:
SELECT 'Use Case #'||usecase.id||': '||usecase.summary as __group__,
story.id AS ticket, story.status AS status, story.summary AS summary,
story.owner AS owner, story.time AS created, sprint.value AS sprint,
usecase.milestone,
(CASE story.status
WHEN 'new' THEN 1
WHEN 'assigned' THEN 2
WHEN 'accepted' THEN 2
WHEN 'closed' THEN 5
ELSE 3
END) AS __color__
FROM ticket story
LEFT JOIN agilo_link link ON story.id=link.dest
LEFT JOIN ticket usecase ON link.src=usecase.id
LEFT JOIN ticket_custom sprint ON sprint.ticket=story.id AND
sprint.name='sprint'
WHERE usecase.id NOT NULL
AND usecase.type='requirement'
ORDER BY usecase.id
Cheers
Stefano Rago
--
Follow Agilo on Twitter: http://twitter.com/agiloforscrum
Please support us by reviewing and voting on:
http://userstories.com/products/8-agilo-for-scrum
http://ohloh.net/p/agilo-scrum
http://freshmeat.net/projects/agiloforscrum
You have received this message because you are subscribed to
the "Agilo for Scrum" Google Group. This group is focused on
supporting Agilo for Scrum users and is moderated by
Agilo Software GmbH <http://www.agiloforscrum.com>.
To post to this group, send email to [email protected]
To unsubscribe from this group, send an email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/agilo
