I am wanting to create a JQL search that will look for all issues within a specific project's current sprint that have time logged within the last 36 hours.
Hi @Margaret Hodges,
I am not sure about a JQL statement that would search back exactly 36 hours from now, but the following will get you quite close:
Project = <your project> AND Sprint in OpenSprints() AND WorkLogDate >= StartOfDay(-1)
Sprint in OpenSprints() will dynamically fetch the current sprint. WorkLogDate >= StartOfDay(-1) will fetch all issues with worklogs after the start of the previous day.
It’s possible to set exactly the last 36 hours or any other time in Dynamic Filters: JQL Replacer add-on. It’s developed by my team to simplify JQL requests. So you can select all the required data with the help of Smart Field Manager as shown below:
Here is how you set the worklog date you need:
At last, just select created Smart Fields to get them shown:
Hope you find it helpful.
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events