nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Create a JQL to search for worked logged within the last 36 hours?

Margaret Hodges

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.

Accepted answers

Yuliia_Borivets__SaaSJet_

Hi @Margaret Hodges

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:

smart field.png

Hope you find it helpful.

Regards

All comments

Walter Buggenhout

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.