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

Lyndoln Gardon 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 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