I'm using MySQL. With the front-end app I'm using to view the data in the database I do see Views, Stored Procs, and Functions. Never used them and don't know what they are. I know this probably isn't too hard to do, it's just something new to me. Chris
________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of De La Camara Juan Matias Sent: Thursday, August 16, 2007 5:18 PM To: [email protected] Subject: [Trac] Re: Taking "Active Tickets, Mine First" to the Next Level I think the solution depends on what kind of DBMS you are using. A Basic fashion to solve this could be an GROUP sentence in your SQL query. So you can group the results and then show them by group (in the presentation layer, of course). The other solutions depends on the fact if your DBMS has views or stored procedures. So, what DBMS do you have, Chris? Regards. Juan Matias (you can hack the TRAC reports, they have SQL queries to retrieve the data in this fashion) ________________________________ De: [email protected] [mailto:[EMAIL PROTECTED] En nombre de Wetterman, Christopher Enviado el: Jueves, 16 de Agosto de 2007 02:04 p.m. Para: [email protected] Asunto: [Trac] Taking "Active Tickets, Mine First" to the Next Level 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 -~----------~----~----~----~------~----~------~--~---
