Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL status at specific time of day every month

Manuel Venegas
Contributor
May 21, 2020

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.

1 answer

0 votes
Haran Kumar
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
May 22, 2020 edited

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
atlassian, mindful member, mindful member badge, atlassian community, community kudos, community giveaway, atlassian swag, community values, empathy and kindness, badge challenge, atlassian learning, community engagement, swag giveaway

Earn a Badge, Win a Prize 🎁

Earning the Mindful Member badge proves you know how to lead with kindness, plus it enters you into a giveaway for exclusive Atlassian swag. Take the quiz, grab the badge, and comment on our announcement article to spread the good vibes!

Start here
AUG Leaders

Atlassian Community Events