I have a "group dashboard" which shows tasks by owner sorted by milestone due
date:
SELECT p.value AS __color__,
(CASE WHEN owner ISNULL THEN ' * Unassigned * ' ELSE owner END) AS __group__,
id AS ticket, summary, milestone, priority,
est.value as 'Est.', act.value as 'Act.',
date(milestone.Due,'unixepoch') as due,
status,
changetime AS _changetime, t.description AS _description
FROM ticket t, enum p
JOIN milestone ON milestone.name=t.milestone
LEFT OUTER JOIN ticket_custom est ON
(t.id=est.ticket AND est.name='estimatedhours')
LEFT OUTER JOIN ticket_custom act ON
(t.id=act.ticket AND act.name='totalhours')
WHERE status <> 'closed'
AND p.name = t.priority AND p.type = 'priority'
AND est.name = 'estimatedhours'
ORDER BY owner, milestone.Due, p.value, t.type, time
But as I plan future work, I have items that are not due for months and I have
people with lots of tickets. To focus on the most important/urgent items, I'd
like to limit the report to the top 5 tickets per owner. I suspect the SQLite
LIMIT option is the key but I don't know how to apply that per group. Any
pointers would be appreciated. Thanks.
--
Christopher Nelson
___________________________________________________
SIXNET - Innovative. Open. Industrial Data Products.
PO Box 767, 331 Ushers Road, Clifton Park, NY 12065
Phone: +1(518)877-5173, Facsimile: +1(518)877-8346
E-mail: mailto:[EMAIL PROTECTED]
Get product details at http://www.sixnetio.com
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac
Users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---
