Jeff,
I upgraded to 0.11 without any problems and now I can select columns for my query results. You're right about the query module - it's very nice. And now that I'm on 0.11, I'm looking forward to customizing my ticket workflows. Thanks for your help! Dave ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Webb Sent: Wednesday, September 26, 2007 1:27 PM To: [email protected] Subject: [Trac] Re: Showing custom fields in query results short answer - yes :-) I had the TimeAndEstimation plug-in installed and this was most of the pain. That pain came from having to build the TAE plug-in for 0.11 because the version of Genshi it requires is not in the base Trac 0.11 install. If you have a vanilla install I believe the upgrade should be pretty easy. I tested in a sandbox first of course (and backed everything up) and it took a few hours to get upgraded with the plug-ins installed. I would highly recommend 0.11. The TracQuery module rocks. The ability to navigate tickets within this framework is much improved. And you get the admin section so you don't have to use the command-line interface. We're still missing the ability to bulk-update a group of tickets but the ticket navigation makes that process much easier now. Jeff On 9/26/07, Peckham, David <[EMAIL PROTECTED]> wrote: Adding col=xxxx didn't work for me, probably because I'm using 0.10.4. Did you encounter any problems upgrading to 0.11? ________________________________ From: [email protected] [mailto: [email protected] <mailto:[email protected]> ] On Behalf Of Jeff Webb Sent: Wednesday, September 26, 2007 12:09 PM To: [email protected] Subject: [Trac] Re: Showing custom fields in query results 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] <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/ -- 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 -~----------~----~----~----~------~----~------~--~---
