custom reports says ticket-custom but documentation says custum_ticket field
|Reported by:||Owned by:||Jonas Borgström|
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…
|' *' 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.