Well, if you're ever uncertain about the schema, it's defined in the Trac source code in db_default.py. For example, for version 0.10.4 you can view this at http://trac.edgewall.org/browser/tags/trac-0.10.4/trac/db_default.py. Also, if you have the sqlite3 command line utility you can always use that.
As for ordering by milestone due date, the basic query might look something like: SELECT t.* FROM ticket t LEFT JOIN milestone m ON t.milestone = m.name ORDER by m.due; Of course, you would want to look at other reports to get an idea of how to add more styles and formatting to that. On 5/28/07, perk <[EMAIL PROTECTED]> wrote: > > I'd like to order a report by Milestone due date > > Is anyone able to assist me with the formatting for this? I can't see > the db to get the field title. > > CHEERS > > |***| > \__/ > > > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
