Can't see source of reports here on edgewall trac

[GreenAsJade <trac@…>]

Examples are gold. Look at all those tantalising reports, like "Issues resolved since" etc.

But I can't see the SQL for them!

Could this be enabled?

Thx!

[anonymous]

You can easily create a custom query to do the issues resolved since reports. You should really try using custom query and creating defects against it since the reports module will be removed in the near future(currently slated for milestone:0.12).

[Christian Boos]

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.
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