Thank you, Manu.

On Mar 22, 2006, at 11:34 AM, Emmanuel Blot wrote:

There are stored in the ticket_custom table where:

CREATE TABLE ticket_custom (
       ticket               integer,
       name             text,
       value            text,
       UNIQUE(ticket,name)
);

ticket is the ticket number
name is the name of the custom field
value is the value of the custom field

i.e. if you have two custom fields tied to a ticket, you'll have a
pair of ticket_custom row with the same ticket number.

HTH,
Manu

On 3/22/06, Doug Knesek <[EMAIL PROTECTED]> wrote:
Hello,

I want to include some custom ticket fields that I have defined in
trac.ini in some reports.  Does anyone know generally how these
fields are referenced in SQL?

- Doug
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac



--
Manu
_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac

_______________________________________________
Trac mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac

Reply via email to