Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Deleted user
Level
0 / 0 points
Next:
badges earned

Your Points Tracker
Challenges
Leaderboard
  • Global
  • Feed

Badge for your thoughts?

You're enrolled in our new beta rewards program. Join our group to get the inside scoop and share your feedback.

Join group
Recognition
Give the gift of kudos
You have 0 kudos available to give
Who do you want to recognize?
Why do you want to recognize them?
Kudos
Great job appreciating your peers!
Check back soon to give more kudos.

Past Kudos Given
No kudos given
You haven't given any kudos yet. Share the love above and you'll see it here.

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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.  

2 answers

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. 

If I use WorkLogDate >= StartOfDay(-3) will it fetch all issues with worklogs after the previous three days? 

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:

jql_replacer.png

Here is how you set the worklog date you need:

worklogdate.png

At last, just select created Smart Fields to get them shown:

smart field.png

 

Hope you find it helpful.

Regards

thank you for the suggestion

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

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

Events near you