JQL status at specific time of day every month

[Manuel Venegas]

Hi community!!!

I've been looking for this one for a while now, but haven't been able to get a proper JQL to help with it.

I'm looking to build a report that illustrates the issues with the assignee field EMPTY at 7:00 am every day for the past 30 days.

I've tried different ways. The was condition only allows me to do so with specific dates, so not handy for looking a list of issues based on a period of last 30 days with that specific condition. Anybody has any idea on how to come up with this? (with no add-ons).

Cheers.

[Haran Kumar]

Hi @Manuel Venegas 

To give a simple answer , There isn't any such features in jira , that allows user to Search for a specific time slice per day for a month using JQL. You can find the below links , where the development team is Gathering interest to bring in this feature. 

https://jira.atlassian.com/browse/JRACLOUD-69417

Source Reference: Click here 

But I would like to give you an idea , which may help you to gather the data. But manually you might have to work on presenting them. 

Created a filter using a JQL to find All unassigned Ticket . This filter will have all unassigned tickets. Subscribe to this filter as a personal subscription and schedule it for daily and mark the interval as once per day at 7.00 am for your case . 

With this being done , every day you will receive the filter results in you mailbox at 7.00am .
At the end of 30 days you may collate this data and use it for you reference. 

I know this is tedious , but just gave you the idea of working your requirements around. 

Hope this was helpful. 

Regards & Wishes
Haran