Changes between Version 13 and Version 14 of TracReports
- Timestamp:
- Nov 15, 2004, 6:07:22 AM (19 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
TracReports
v13 v14 3 3 4 4 The Trac reports module provides a simple, yet powerful reporting facility 5 for presenting information about tickets fromthe Trac database.5 to present information about tickets in the Trac database. 6 6 7 Rather than have its own report format, TracReports relies on standard SQL7 Rather than have its own report definition format, TracReports relies on standard SQL 8 8 SELECT statements for custom report definition. 9 9 … … 14 14 * Report Body -- List of results from report query, formatted according to the methods described below. 15 15 * Footer -- Links to alternative download formats for this report. 16 17 18 == Changing Sort Order == 19 Simple reports - ungrouped reports to be specific - can be changed to be sorted by any column simply by clicking the column header. 20 21 If a column header is a hyperlink (red), click the column you would like to sort by. Clicking the same header again reverses the order. 16 22 17 23 … … 31 37 All reports support syndication using XML/RSS 2.0. To subscribe to a , click the the orange 'XML' icon at the bottom of the page. See TracRss for general information on RSS support in Trac. 32 38 33 == Changing Sort Order ==34 Simple reports - ungrouped reports to be specific - can be changed to be sorted by any column simply by clicking the column header.35 36 If a column header is a hyperlink (red), click the column you would like to sort by. Clicking the same header again reverses the order.37 38 39 ---- 39 40 == Creating Custom Reports == 40 41 41 Creating a custom report requires knowing and using the SQL query language. 42 ''Creating a custom report requires a comfortable knowledge of SQL.'' 42 43 43 44 A report is basically a single named SQL query, executed and presented by … … 130 131 * '''ticket''' -- Ticket ID number. Becomes a hyperlink to that ticket. 131 132 * '''created, modified, date, time''' -- Format cell as a date and/or time. 133 132 134 * '''description''' -- Ticket description field, parsed through the wiki engine. 133 135