Modify ↓

Opened 15 years ago

Closed 15 years ago

#6198 closed defect (worksforme)

Custom Fields for queries

Reported by: Bill Meyer Owned by: Guillermo M Narvaja
Priority: normal Component: TicketStatsMacro
Severity: normal Keywords:
Cc: Trac Release: 0.11

Description

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 15 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 15 years ago by Bill Meyer

Resolution: → worksforme
Status: new → closed

Thanks Works

Modify Ticket

Change Properties
Set your email in Preferences
Action
as closed The owner will remain Guillermo M Narvaja.
The resolution will be deleted. Next status will be 'reopened'.

Add Comment

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

Attachments ↑ Description ↑
 
Note: See TracTickets for help on using tickets.