#3342: Can't see source of reports here on edgewall trac
----------------------------------------------+-----------------------------
Reporter: GreenAsJade <[EMAIL PROTECTED]> | Owner: jonas
Type: enhancement | Status: closed
Priority: normal | Milestone:
Component: ticket system | Version: 0.9.5
Severity: normal | Resolution: wontfix
Keywords: |
----------------------------------------------+-----------------------------
Changes (by cboos):
* resolution: => wontfix
* status: new => closed
Comment:
Well, the removal of pure SQL queries maybe, but report "objects" as such
(see #1735) ''might'' be kept as a convenient way to store custom queries,
document them, refer to them in Wiki pages (the `{1}` syntax, etc.).
So we'll see.
As for the '''issues resolved since''' using custom queries, this is still
''not'' possible, currently (see #2849 for that).
Lastly, to answer's !GreenAsJade request, you can already find some
examples
in the source:trunk/trac/db_default.py, and in TracReports. [[br]]
The SQL corresponding to the ''Issues resolved since 0.5.2'' report
is fairly basic:
{{{
SELECT id AS ticket,resolution, component, summary
FROM ticket
WHERE status='closed' AND changetime > 1078185600
ORDER BY ticket,component, changetime
}}}
--
Ticket URL: <http://projects.edgewall.com/trac/ticket/3342>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
