Hi to all,
I've got a problem with the trac reports : I'd like to get a report showing the tickets by status. So my query is the following : SELECT p.value AS __color__,status AS __group__,id AS ticket, priority, component,reporter, time as created, summary FROM ticket LEFT JOIN enum p ON p.name = ticket.priority AND p.type = 'priority' WHERE owner = $USER ORDER BY component, priority, time But the tickets I get with this report are not grouped by report but, it seems, by report AND priority. So if I have a 'new' ticket with priority 'high', it will not be in the same group that a 'new' ticket with "minor" priority. Anyone knows why I get this and how I can avoid it? Thanks, Eleonore --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
