custom reports says ticket-custom but documentation says custum_ticket field

[eoin.dunne@…]

drove myself crazy for a while.

I'm running sqlLite for the database back end of trac 0.10.1.

I couldn't get my custom report to work…below is the query that finally worked…

SELECT id AS ticket, summary, version, milestone, (CASE WHEN c.value IS NULL THEN ELSE c.value END) as Time_Estimate, t.type AS type, (CASE status WHEN 'assigned' THEN owner

' *' ELSE owner END) AS owner FROM ticket t, enum p, ticket_custom c

WHERE status IN ('new', 'assigned', 'reopened') AND p.name = t.priority AND p.type = 'priority' AND t.id = c.ticket and c.name = 'time_estimate' ORDER BY milestone, t.type, time

All the documentaion that I've found says that the custom fields table should be accessed using custom_ticket. I kept getting an error saying that custom_ticket table didn't exist. In desperation I tried ticket_custom and voila! it worked.

[Tim Hatch <trac@…>]

Confirmed, documentation bug. TracTicketsCustomFields is the only instance of custom_ticket in a wiki page that I can find, now fixed. This should be in the new wiki-default pages.