Creating a Jira report for specific days and times?

[Darla Sheehan]

Hi,

In a Service Desk project, under Reports, we need a report that shows the tickets that are logged Monday to Thursday 17:00 to 09:00am and Friday to Monday 17:00 to 09:00am. 

Having trouble with a JQL that dos this.

Thanks.

[Felipe Prusch]

Hi Darla! How are you?

As there is no distinct Time field on our built-in JQL solution, there is not a simple way of getting exactly what you want. However, it can be done with something like this:

project = TEST and createdDate >= startOfWeek() AND createdDate <= endOfWeek()

This query above will find tickets created on the current week. However, you want to find tickets created between a time range. Maybe you should try something like this:

project = TEST and createdDate >= "2017/11/06 17:00" AND createdDate <= "2017/11/07 09:00"

This will show you the tickets created on that day between the specified time. You'd have to adapt the query to each day though, or create a big query including all the week days.

To do it in a dynamic way I think that you'd need a thir-party plugin like Eazybi, for example.

Hope it gelps!

[MoroSystems Support]

Hello Darla,

in plain Jira, I think you could try to achieve this with use of  startOfWeek() / endOfWeek() functions (see https://confluence.atlassian.com/jiracoreserver073/advanced-searching-functions-reference-861257222.html)

But it would be quite long and ugly query as you probably have to specify each range (Monday 0:00 to Monday 9:00, Monday 17:00 to Tuesday 9:00, etc.):

(created > startOfWeek() AND created < startOfWeek(+9h)) AND (created > startOfWeek(+17) AND created < startOfWeek(+33h)) ...etc.

It would help you for only current week (with use of startOfWeek() function). this could work. Otherwise, try to search for some clever plugin.