Opened 5 years ago

Closed 5 years ago

#6198 closed defect (worksforme)

Custom Fields for queries

Reported by: billmeyer Owned by: gnarvaja
Priority: normal Component: TicketStatsMacro
Severity: normal Keywords:
Cc: Trac Release: 0.11


When the query includes a Custom Field it returns error:

Error: Macro TicketStats(title = Commercial Tickets past 30 days, daterange=30d,res_days=1, query=custom_fieldname='Yes') failed
no such column: t.custom_fieldname

Is it possible to add query functionality for custom fields?

Attachments (0)

Change History (2)

comment:1 Changed 5 years ago by anonymous

It works for me. I'm using this query, where "client" it's a custom column.

[[TicketStats(title = Tareas últimos 15 días, query=client='lambda'&type='Error', height=250,daterange=120d,res_days=15)]]

I'm using the TicketChartsMacro code for building the query.

Make sure you are using the field name as defined in [ticket-custom] in trac.ini file.

comment:2 Changed 5 years ago by billmeyer

  • Resolution set to worksforme
  • Status changed from new to closed


Add Comment

Modify Ticket

as closed .
as The resolution will be set. Next status will be 'closed'.
to The owner will be changed from gnarvaja. Next status will be 'closed'.
The resolution will be deleted. Next status will be 'reopened'.

E-mail address and user name can be saved in the Preferences.

Note: See TracTickets for help on using tickets.