问题描述
Jira Server v7.12.1#712002
Jira Server v7.12.1#712002
我们已经注意到，在一天中的某些时段，分配给操作"队列的票证比平时更多，因此我们需要使用真实的统计数据来支持这种印象.
We have noticed that at certain periods of the day there are more tickets assigned to "Operations" queue than usual, so we need to back this impression with real statistics.
我们通过以下查询提取了在某个时刻分配给操作"队列的所有票证:
We extracted all the tickets that at some point were assigned to "Operations" queue via the following query:
project = "Client Services" AND assignee WAS "Operations"
上面的查询结果在"Updated"字段中包含时间戳记值，但是此字段反映了票证的最后更新时间-不是我们想要的.我们需要一个时间戳，以显示票证何时到达操作"队列.
The results of the query above include the timestamp value in the "Updated" field, however this field reflects the last time the ticket was updated - not what we want. We want a timestamp which shows when the ticket arrived to "Operations" queue.
门票可以通过两种方式到达:
The tickets can arrive in two ways:
1)门票可能来自其他队伍.在这种情况下，我们可以在历史记录"选项卡下观察3个不同字段如何更改其值.例如，如果车票来自某些乔·史密斯，它将看起来像这样:
1) Ticket may come from other teams. In such cases, under History tab we can observe how 3 different fields change their values. For example, if ticket comes from certain Joe Smith, it would look like this:
FIELD ORIGINAL VALUE NEW VALUE
Joe Smith made changes - 09/04/2020 12:08
Assignee Joe Smith Operations
2)可以直接(由其他团队)创建票证.在这种情况下，历史记录"标签下的前2个条目始终具有以下模式:
2) Ticket may be created directly (by other teams). In such cases the first 2 entries under History tab always have this pattern:
Joe Smith created issue - 02/04/2020 19:27
_______________________________________________________________________________________________________
Joe Smith made changes - 02/04/2020 19:27
FIELD ORIGINAL VALUE NEW VALUE
Link Referred from ABC-12345
上面的模式是created issue和made changes始终具有相同的时间戳.
The pattern above is that created issue and made changes always have the identical timestamps.
基于这些示例，是否有某种方法可以提取所有票证到达操作"队列的时间戳?如果不使用JQL，也许存在其他解决方案/工具?
Based on these examples, is there some way to extract the timestamps of all tickets' arrival to "Operations" queue? If not with JQL, maybe some other solution/tool exists?
推荐答案
可以通过两种方式实现大部分要求:
There can be two ways you could achieve most of what you've asked for:
-
使用最近创建的图表 JIRA小工具.
- 通过此操作，您可以清晰地了解一天中一个小时内所获得的门票数量.
或者您可以使用Created Vs Resolved内置JIRA报告
Or you could use the Created Vs Resolved built-in JIRA report
- 这有助于从票证中获取更好的信息，进行一些分析等.
您可以在 Atlassian社区论坛.希望这个答案有帮助！
You could find more details from this answer on Atlassian Community forum. Hope this answer helps!
这篇关于Jira JQL:如何查找队列中最繁忙的时间?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！