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

最新推荐文章于 2021-06-14 23:14:51 发布

胡争辉

最新推荐文章于 2021-06-14 23:14:51 发布

阅读量2.2k

点赞数

分类专栏： Trac 文章标签： workflow report 报表 sorting 数据结构 browser

本文为博主（@胡争辉）原创文章，未经博主允许不得转载。

本文链接：https://blog.csdn.net/hu_zhenghui/article/details/2230930

版权

Trac 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

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