On May 18, 9:47 am, eri x <[email protected]> wrote: > Hi, is there a mode to get the number and names of ticket types used in a > trac instance, i saw the database schema but there is not a ticet_type > field.
There is a "type" field, in the "ticket" table. This will tell you how many you have of each. SELECT type, count(type) FROM ticket GROUP BY type; If you want to know what the allowable types are, regardless of whether there are any tickets of that type, look in the enum table: SELECT * FROM enum WHERE type = 'ticket_type'; =-=-> Jenn Drummond // [email protected] Project Developer, Connexions Project (cnx.org) Rice University --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Development" 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-dev?hl=en -~----------~----~----~----~------~----~------~--~---
