获取 Trac 的估算和时间跟踪插件中增加的小时数

发布于 2024-08-10 04:45:12 字数 491 浏览 7 评论 0原文

我想创建一个查询来显示工单中所有添加的小时数（如向工单添加工时）。

假设我们有开发人员：John、Fred 和 Peter，以及门票 Foo 和 Bar。我想看到这样的东西：

Ticket  Developer   At      HoursTotal
-------------------------------------
Bar     John        11:00   0.8 hours
Bar     Fred        10:13   2.0 hours
Foo     Peter       09:50   1.0 hours
Foo     John        09:00   0.5 hours

原文

We are using Estimation and Time Tracking plugin for Trac.

I want to create the query that would show all additions of hours to tickets (As in Add Hours to Ticket).

Let's say we have developers: John, Fred and Peter and tickets Foo and Bar. I want to see something like this:

Ticket  Developer   At      HoursTotal
-------------------------------------
Bar     John        11:00   0.8 hours
Bar     Fred        10:13   2.0 hours
Foo     Peter       09:50   1.0 hours
Foo     John        09:00   0.5 hours

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

郁金香雨 2024-08-17 04:45:12

愚蠢的我，类似的东西包含在插件中。但这就是创建上面表格的内容：

 SELECT
   t.id AS ticket,
   t.summary AS summary,
   author,
   ticket_change.time AS datetime,
   newvalue AS HoursTotal
 FROM ticket_change
 JOIN ticket t ON t.id = ticket_change.ticket
 WHERE field = 'hours'

Silly me, something like that is included in the plugin. But this is what will create the table above:

 SELECT
   t.id AS ticket,
   t.summary AS summary,
   author,
   ticket_change.time AS datetime,
   newvalue AS HoursTotal
 FROM ticket_change
 JOIN ticket t ON t.id = ticket_change.ticket
 WHERE field = 'hours'

回复收藏 0 原文

~没有更多了~