Am 06.10.2010 11:00, schrieb janiv:
How do I create report for a specific team? using SQL or standard
report (filter, column, and group by)
i.e. where user in team "my team"
My first question is how you associate bugs with a specific team?
Assuming that a bug is associated if the owner is part of the team, you
could put this in a report:
SELECT id AS ticket, summary, milestone FROM ticket t where
type='bug' and
status != 'closed' and
owner in (select name from agilo_team_member where team='$team')
If you save this as a report in Agilo, you can dynamically select the
open bugs for the team 'MyTeam' by going to '/report/9?team=MyTeam'.
fs
--
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
