I like the separation of the tickets you own and the remaining ones out there. With that I would like a further break down separating out the components under Active Tickets, but alas my python SQL knowledge isn't up to par. Does anyone know how the SQL query would be formatted for this? For example, lets say when creating a ticket you have the option to choose "GUI", "Component 1", "Component 2" and "Component 3" from the components drop down. Now when you view the report it'll be organized something like this. I also have custom fields on each ticket that I would like to include as well. - My Tickets ticket 1 ticket 2 ticket 3 -Active Tickets -- GUI ticket 4 ticket 5 -- Component 1 ticket 6 -- Component 2 ticket 7 ticket 8 ticket 9 ticket 10 -- Component 3 ticket 11 In addition, if there are no tickets for a particular component can you add a row under that header saying "No bugs reported."? Thanks. Chris
--~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
