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

Question

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")

PVS · Answer

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

Lyndoln Gardon · Answer

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 · Answer

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