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
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
