I need a JQL search in JIRA which finds issues created during nighttime. Can someone tell me if it is possible?
something like "created after 1:00AM and created before 7:00AM and created after 1.1.2015 and created before 31.12.2015".
As far as I know you can search for issues created in a specified time interval for a specific date, but you can't search for issues by time for a date range.
For example to find the issues created between 1AM and 7AM today you can use the query below:
created >=startOfDay(1h) AND created <= startOfDay(7h)
If you want to search for the same in a date range - you may try to create a custom post-function. I'm not aware of an add-on providing such functionality but you may try searching the marketplace for such an add-on.
I was able to achieve this. Here's how I did it.
For this example, assume you want to split tickets into those submitted between 9am and 5pm aka "business hours" and tickets submitted before 9am or after 5pm aka "non-business hours" tickets so you can measure how many tickets come during each time period on an ongoing basis.
NOTE: This solution will only work for future-looking tickets
If you wanted to apply this to historic data, I'd suggest downloading all of the data you care about, then using excel to split it into the right buckets, and then using the bulk update function to update the labels to match the above.
Of course if you wanted to be even more specific about this, you could create a label for each hour of the day, and then be able to modify the definition of the groups more easily (for example, if you wanted to move business hours to be 8am - 4pm, it would be more difficult with the solution proposed above)
For JSM June Challenge #2, share how your non-technical teams like HR, legal, marketing, finance, and beyond started using Jira Service Management! Tell us: Did they ask to start using it or...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events