Hi. To identify bottlenecks and late requests, I need to be able to identify requests that come through to us based on the absolute time that they first transitioned into "Waiting for Support."
I want to be able to run a quick search along the lines of
{Project = X and WaitingForSupport > 16:00} for example...
... so I can see what requests come in after 17:00 etc etc
If anyone can advise how this might be achieved that would be great.
The above answer only works for current day.
You can use Power Scripts for Jira
For example
key in silJQLExpression("(dayOfWeek(created) == \"Sat\") or (dayOfWeek(created) == \"Sun\") or (hour(created) >=19) or (hour (created) <= 6) ", "project = SD and created >= 2019-01-01 and created < 2019-10-01")
Hello,
You can may be create a date/time customfield and add it to your screen.
Add a postfunction that will automatically fill the field with the date of the transition.
Create a jql that like:
Customfield date > startofday("+16h").
The start of day is midnight so with this query you will be able to find issue where the date in the field is bigger that 16:00.
Some documentation here about startofday() :
Hope this helps
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.