Edgewall Software
Modify

Opened 16 years ago

Closed 16 years ago

#4197 closed defect (fixed)

custom reports says ticket-custom but documentation says custum_ticket field

Reported by: eoin.dunne@… Owned by: Jonas Borgström
Priority: normal Milestone: 0.11
Component: ticket system Version: 0.10.1
Severity: normal Keywords: custom documentation
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:

Description

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.

Attachments (0)

Change History (1)

comment:1 by Tim Hatch <trac@…>, 16 years ago

Component: generalticket system
Keywords: documentation added
Milestone: 0.11
Resolution: fixed
Status: newclosed

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.

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Jonas Borgström.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Jonas Borgström to the specified user.

Add Comment


E-mail address and name can be saved in the Preferences .
 
Note: See TracTickets for help on using tickets.