Trac/チケット集計
をテンプレートにして作成
[
トップ
] [
新規
|
一覧
|
検索
|
最終更新
|
ヘルプ
|
ログイン
]
開始行:
* [[Trac]]/チケット集計 [#h1bd5cad]
#contents
&tag(Trac);
* 集計 [#c2607437]
- [[sqliteがバックエンドの時のTracReportを書くtips — あり...
- [[sqlite - How to create report with tickets closed at ...
- チケットのクローズ日 ([[SQLite]])
SELECT DISTINCT ticket.id, date(ticket_change.time/10000...
FROM ticket, ticket_change
WHERE ticket.id = ticket_change.ticket
AND ticket_change.field = 'status'
AND ticket_change.newvalue = 'closed'
AND strftime('%Y', ticket_change.time/1000000, 'unixep...
ORDER BY date(ticket_change.time/1000000,'unixepoch');
- 月別のクローズ件数
SELECT DISTINCT count(*), strftime('%Y-%m', ticket_chang...
FROM ticket, ticket_change
WHERE ticket.id = ticket_change.ticket
AND ticket_change.field = 'status'
AND ticket_change.newvalue = 'closed'
GROUP BY year_month
ORDER BY ticket_change.time
終了行:
* [[Trac]]/チケット集計 [#h1bd5cad]
#contents
&tag(Trac);
* 集計 [#c2607437]
- [[sqliteがバックエンドの時のTracReportを書くtips — あり...
- [[sqlite - How to create report with tickets closed at ...
- チケットのクローズ日 ([[SQLite]])
SELECT DISTINCT ticket.id, date(ticket_change.time/10000...
FROM ticket, ticket_change
WHERE ticket.id = ticket_change.ticket
AND ticket_change.field = 'status'
AND ticket_change.newvalue = 'closed'
AND strftime('%Y', ticket_change.time/1000000, 'unixep...
ORDER BY date(ticket_change.time/1000000,'unixepoch');
- 月別のクローズ件数
SELECT DISTINCT count(*), strftime('%Y-%m', ticket_chang...
FROM ticket, ticket_change
WHERE ticket.id = ticket_change.ticket
AND ticket_change.field = 'status'
AND ticket_change.newvalue = 'closed'
GROUP BY year_month
ORDER BY ticket_change.time
ページ名:
![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
