Hi Janiv,
The easiest thing that you could do is to set the
backlog_filter_attribute to 'owner' in the [agilo-general] section of
the trac.ini file. This will produce an option at the top of the
backlog menu where you can select a user by which to filter.
Otherwise, the information that you need is available, but it would
require several joins to get the report to work. Specifically, you'd
need to join ticket.id to ticket_custom.ticket where
ticket_custom.name = 'sprint' and then join that to agilo_sprint where
name = ticket_custom.value. Here is an example that might help:
-- snip --
-- Show Requirements and Stories
--
-- Needs to specify Variable MILESTONE in the URL like this '?MILESTONE=foo'
SELECT 'Requirement #'||requirement.id||': '||requirement.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 requirement ON link.src=requirement.id
LEFT JOIN ticket_custom sprint ON sprint.ticket=story.id AND
sprint.name='sprint'
WHERE requirement.id NOT NULL
AND requirement.milestone=$MILESTONE
AND requirement.type='requirement'
ORDER BY requirement.id
-- snip --
Hope this helps,
Thom
On Wed, Jun 23, 2010 at 9:08 AM, janiv <[email protected]> wrote:
>
> Hi,
> We'd like to have a report that describes the current sprint tasks by
> users.
> We couldn't find a way to create a report which its sprint field is
> set to current sprint (as we have $user to represent current user).
> Is there any way to add such a field or to use such one?
>
> Thanks,
> Janiv Ratson.
>
> --
> 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
> agile42 GmbH <http://www.agile42.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
--
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
agile42 GmbH <http://www.agile42.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
