JQL Filter that shows the last time work was logged on cases in a active sprint.

Michelle Salguero

I would like to run a JQL query that returns all the cases in my project active sprint. I would like to have a column in the results that tells me the last time a work log was entered. I have a JQL query set up to pull all the cases in the active sprint but I'm not sure how I can get the results to also include the last time a work log was added. The "last updated' column would not be accurate b/c it would take status changes/comments into consideration. I specifically want to know when was the last date a work log was added. 

 

I am working with a team that is struggling to keep their logs updated. This would make our PMs life a lot easier. Any suggestions on what I can do to get these results? 

Bill Sheboy

Hi @Michelle Salguero -- Welcome to the Atlassian Community!

While using a JQL filter search, I do not believe you can display that information with out-of-the-box features.  There may be a marketplace app which can do this.

As a work-around, if you build your filter and export all fields, you could get all the work logged entries from the Log Work fields. 

The challenge is that for a field like this, Jira adds a column for each log entry, per issue.  (Similar to comments and sprint.)  So you will need to build a formula to find the last populated column named Log Work, per row, and then split out the data/time value from the author and logged time amount.

Kind regards,
Bill