Forums

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

Display all resolved/closed issue today form 6am until 2pm of the day only using JQL

Lyndoln Gardon
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 23, 2019

Hi Team. Im using report below to display all resolved/closed issue of the day from 6am until 2pm via JQL. Is there a was to make it dynamic so i dont have to input the dates?

 

 

project = "Incidents" and status changed TO (Closed, Resolved) DURING ("2019/09/23 14:00","2019/09/23 21:00")

1 answer

0 votes
PVS
Banned
September 23, 2019

hi @Lyndoln Gardon 

Try this

project = "XYZ AND issuetype = bug AND status changed to closed AND updatedDate > "2019/09/24 00:00" AND updatedDate < "2019/09/24 00:00"

 

or

project = XYZ AND issuetype = bug AND status changed to closed DURING ("2019/09/24 00:00","2019/09/24")

 

Thanks,

PVS

Lyndoln Gardon
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
September 23, 2019

Hi Team, thanks for the quick response. Is their a way to make it dynamic where i dont have to manually enter the date? I will need to run the script daily and get the results from the specific time only.  

PVS
Banned
September 23, 2019

Hi @Lyndoln Gardon 

 

You Will Save The JQL That time U will See daily Like that and get the results from the specific time only.

 

Thanks ,

PVS

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events