[prev in list] [next in list] [prev in thread] [next in thread] 

List:       trac
Subject:    [Trac] Re: Report ORDER BY Milestone Due Date
From:       "Erik Bray" <hyugaricdeau () gmail ! com>
Date:       2007-05-29 16:40:23
Message-ID: e71e26940705290940q4efec5cbn7e81b0fa6271eb1d () mail ! gmail ! com
[Download RAW message or body]


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 <dirtysweetgirl@gmail.com> 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 trac-users@googlegroups.com
To unsubscribe from this group, send email to trac-users-unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/trac-users?hl=en
-~----------~----~----~----~------~----~------~--~---

[prev in list] [next in list] [prev in thread] [next in thread]