Has anyone created a similar report like this for the Sprint backlog? On Jul 28, 2:26 am, jmb <[email protected]> wrote: > On Jul 27, 1:16 pm, Thomas Lehmann <[email protected]> wrote:> - > Printing: Does anybody have an example on how to provide stories in > > printed form for a team estimation meeting using agilo? > > You can define a report using the following SQL query: > > ==============================8<------------------------------ > SELECT > p.value AS __color__, > id as ticket, > summary, > t.type as type, > coalesce ((SELECT cst.value > FROM ticket_custom cst > WHERE cst.name = 'rd_points' > AND cst.ticket = id), > (SELECT SUM (cst.value) > FROM ticket_custom cst > WHERE cst.name = 'rd_points' > AND EXISTS (SELECT * > FROM agilo_link > WHERE src = t.id > AND dest = cst.ticket)), > '') > as complexity, > ifnull ((SELECT cst.value > FROM ticket_custom cst > WHERE cst.name = 'businessvalue' > AND cst.ticket = id), > '') > as value, > status > FROM > enum p, > ticket t > WHERE > p.name = t.type > AND p.type = 'ticket_type' > AND (t.type = 'requirement' OR t.type = 'story') > > ORDER BY > coalesce ((SELECT pos > FROM agilo_backlog_ticket > WHERE ticket_id = id), > (SELECT pos > FROM agilo_backlog_ticket, > agilo_link > WHERE dest = id > AND name = 'Product Backlog' > AND ticket_id = src), > 99999999), > (CASE > WHEN t.type = 'requirement' THEN 0 > ELSE ifnull ((SELECT pos > FROM agilo_backlog_ticket > WHERE ticket_id = id), > 99999999) > END), > id > ------------------------------>8============================== > > Then save it as CSV. I have an Excel file which can import the CSV and > format it nicely. The report only includes requirements and user > stories since management shouldn't need to bother with tasks, but it > wouldn't be difficult to add the tasks. > > Jerome > > PS: How can I attach the Excel file?
-- 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
