The custom values are stored in the ticket_custom table. The columns are ticket, name, and value. Ticket holds the ticket id, name holds the field name, and value holds the field value. It's quite a cumbersome way to do things but it works.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of RJOllos Sent: Monday, June 29, 2009 7:51 PM To: Trac Users Subject: [Trac] Query options of a custom field Hi, I would like to list the options of a custom field in a wiki page. Using the WikiTable macro [1] I've been able to do this for fields of a ticket that have their own table or exist in a table of the database, such as component and resolution. SELECT name, description FROM component ORDER BY name SELECT name FROM enum WHERE type = 'resolution' However, I don't understand from looking at the database schema [2] if/ where the options of a custom field or stored, though I think that I understand that the actual value of a custom field is stored in the database rather than a key. [1] http://trac-hacks.org/wiki/WikiTableMacro [2] http://trac.edgewall.org/wiki/TracDev/DatabaseSchema Thanks! --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
