No solution for my problem ?
Anyway, I've got another one : I have two fields in ticket_custom I'd like to show in some reports. But the examples in http://trac.edgewall.org/wiki/TracReports only show situations with one custom field. So if someone could show me an example of report using two custom fields, that would be greatly appreciated. Thanks a lot! Eleonore ________________________________ De : [email protected] [mailto:[EMAIL PROTECTED] De la part de Eleonore DUVELLE Envoyé : lundi 21 juillet 2008 11:59 À : [email protected] Objet : [Trac] report grouped by status 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 -~----------~----~----~----~------~----~------~--~---
