Trac - Creating Custom Reports - 创建自定义报表

Creating Custom Reports

Creating a custom report requires a comfortable knowledge of SQL.

A report is basically a single named SQL query, executed and presented by Trac. Reports can be viewed and created from a custom SQL expression directly in from the web interface.

Typically, a report consists of a SELECT-expression from the 'ticket' table, using the available columns and sorting the way you want it.

Ticket columns

The ticket table has the following columns:

• id
• type
• time
• changetime
• component
• severity
• priority
• owner
• reporter
• cc
• version
• milestone
• status
• resolution
• summary
• description
• keywords

See TracTickets for a detailed description of the column fields.

all active tickets, sorted by priority and time

Example: All active tickets, sorted by priority and time

SELECT id AS ticket, status, severity, priority, owner, 
       time as created, summary FROM ticket 
  WHERE status IN ('new', 'assigned', 'reopened')
  ORDER BY priority, time

[Creating Custom Reports - 创建自定义报表 - 文档]

http://trac.edgewall.org/wiki/TracReports#CreatingCustomReports

[Trac - 关键词]

Trac

[Trac - 相关论坛]

http://groups.google.com/group/trac-announce
http://groups.google.com/group/trac-dev
http://groups.google.com/group/trac-tickets
http://groups.google.com/group/trac-users
http://softeng.board.newsmth.net/

[Trac - 下载]

源代码SVN, http://svn.edgewall.com/repos/trac
下载, http://trac.edgewall.org/wiki/TracDownload

[Trac - 基础知识]

Trac源代码格式化，http://trac.edgewall.org/wiki/WikiProcessors

Trac Links，http://trac.edgewall.org/wiki/TracLinks

The Trac Ticket Workflow System - Trac Ticket工作流系统, http://trac.edgewall.org/wiki/TracWorkflow

WorkFlow - 工作流程, http://trac.edgewall.org/wiki/WorkFlow

The Trac Configuration File - 配置文件, http://trac.edgewall.org/wiki/TracIni

Trac Database Schema - 数据结构, http://trac.edgewall.org/wiki/TracDev/DatabaseSchema

Creating Custom Reports - 创建自定义报表, http://trac.edgewall.org/wiki/TracReports#CreatingCustomReports

[Trac - 常见问题]

Trac导出的csv格式文件在Excel中处理unix时间戳

通过URL的querystring设置新ticket的默认属性

Trac中wiki恢复历史版本

browser定位文件行数