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