Edgewall Software

Opened 16 years ago

Closed 16 years ago

#3342 closed enhancement (wontfix)

Can't see source of reports here on edgewall trac

Reported by: GreenAsJade <trac@…> Owned by: Jonas Borgström
Priority: normal Milestone:
Component: ticket system Version: 0.9.5
Severity: normal Keywords:
Cc: Branch:
Release Notes:
API Changes:
Internal Changes:


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?


Attachments (0)

Change History (2)

comment:1 by anonymous, 16 years ago

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

comment:2 by Christian Boos, 16 years ago

Resolution: wontfix
Status: newclosed

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

Modify Ticket

Change Properties
Set your email in Preferences
as closed The owner will remain Jonas Borgström.
The resolution will be deleted. Next status will be 'reopened'.
to The owner will be changed from Jonas Borgström to the specified user.

Add Comment

E-mail address and name can be saved in the Preferences .
Note: See TracTickets for help on using tickets.