On Jul 9, 11:14 am, Eli Carter <[EMAIL PROTECTED]> wrote: > 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.
My understanding from what I read was that the reports module was replaced by the queries. I found and removed the line in the trac.ini file that disables reports, but I still cannot find where in the interface they are. I still get queries only when I go to View Tickets. I'm looking for a way to enter an SQL statement into Trac somewhere. I think I'm getting frustrated too easily on this one. > > 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. Wonderful! I am an SQL detractor, but if there is no other way to get the data out, then that is what I'm searching for. I'm hoping that if I go to lunch, when I come back that Reports/SQL option will be an obvious click or two away. Thanks. --dawn > Another approach, if you are able to modify your Trac install is to pull > something fromhttp://trac.edgewall.org/ticket/2821. > The branch might also be > handy:http://trac.edgewall.org/log/sandbox/ticket-2821?action=path_history&;... > > HTH, > > Eli- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
