What version are you using? I am using Trac 0.11 and this works quite well.
From the UI would have to expand the "Columns" section (2nd section at the top of the screen). If you wanted to edit a custom query it would look something like: query:?status=new&status=accepted&status=reopened&status=assigned &group=owner &order=priority &col=summary&col=milestone&col=<custom_field> &component=<my_component>&<custom_field>=<custom_value> that would show all open tickets (non-closed) grouped by owner for a specific component and for a specific custom field. what version of Trac are you using? On 9/26/07, Peckham, David <[EMAIL PROTECTED]> wrote: > > 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]> wrote: > > This works for TracReports, but reports are deprecated. How would you do > this using TracQuery? > > > > Thanks, > > Dave > > > ------------------------------ > > *From:* [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/ > > > > > -- 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 -~----------~----~----~----~------~----~------~--~---
