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/ --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
