On Monday 09 July 2007, dawn wrote: > > On Jul 9, 9:35 am, Eli Carter <[EMAIL PROTECTED]> wrote: > > On Monday 09 July 2007, dawn wrote: > > > > > This is likely right under my nose, but I cannot seem to figure out > > > how to add fields to a query result on the View Ticket page's custom > > > query. I would like to see the Severity column, for example, or at > > > least be able to download the data from that column as well as those > > > shown. I can group by it, in which case it shows on the screen in > > > group headers but is not in the comma-delimited export. > > > > > I thought this was going to be the easy field to add, since it comes > > > standard. My next feat is to figure out how to include a custom field > > > (which has already been added) in the output list, so if the response > > > can give me a head start with that too, so much the better. Thanks > > > for any tips or links to the right place in the documentation. So far > > > I have only found how to do the qualifications for which rows to > > > display, not which columns. > > > > 0.11dev has this... > > > > Eli > > Thanks, Eli. I am on 0.10.4 Is it really the case that in the > version I have we can add custom fields and collect data, but we > cannot get them in a report or downloaded?
You can get additional columns in the reports; but I thought your question was about the custom queries. > I'm guessing that then the developers are expecting us to issue SQL > queries against the repository to get the data out? I'm thinking I > should be able to set up a data source for Excel to grab the data, for > example, but I haven't used MySQL lately and the last time I did, it > didn't install with ODBC or JDBC access out of the box. The reports are just SQL. Another approach, if you are able to modify your Trac install is to pull something from http://trac.edgewall.org/ticket/2821. The branch might also be handy: http://trac.edgewall.org/log/sandbox/ticket-2821?action=path_history&rev=5415&stop_rev=&mode=stop_on_copy HTH, Eli --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
