I appreciate your help Jeff. I am able to create custom queries that filter and group by any field (including custom fields), however the query results only show the standard fields - I don't see a way to add my custom fields as columns in the results using TracQuery.
I'm guessing that this functionality hasn't been added to TracQuery yet. I should probably open a ticket on the Trac site to request this capability. ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Webb Sent: Wednesday, September 26, 2007 10:39 AM To: [email protected] Subject: [Trac] Re: Showing custom fields in query results you can also simply use the "Create Custom Query" link from the "View Ticket" screen and it will allow you to select these custom fields for display, filtering, and grouping. On 9/26/07, Jeff Webb <[EMAIL PROTECTED]> wrote: simply add the custom field to the query definition.... in the URL you would just add it to the querystring in the form of..... col=<custom_field> if you want to display the column or <custom_field>=<value> if you want to filter a field by a certain value. On 9/26/07, Peckham, David < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > wrote: This works for TracReports, but reports are deprecated. How would you do this using TracQuery? Thanks, Dave ________________________________ From: [email protected] [mailto: [email protected] <mailto:[email protected]> ] On Behalf Of Jeff Webb Sent: Wednesday, September 26, 2007 9:01 AM To: [email protected] Subject: [Trac] Re: Showing custom fields in query results select * from ticket t left join ticket_custom c1 on t.id = c1.ticket and c1.name = '<field_name>' is the basic join you have to make On 9/25/07, David <[EMAIL PROTECTED]> wrote: How do I show custom fields in query results? I'm using 0.10.4. -- Jeff Webb [EMAIL PROTECTED] http://boowebb.com/ -- Jeff Webb [EMAIL PROTECTED] http://boowebb.com/ -- Jeff Webb [EMAIL PROTECTED] http://boowebb.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Trac Users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/trac-users?hl=en -~----------~----~----~----~------~----~------~--~---
