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

Reply via email to