Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

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

How to Search/filter issues with Logged Work in the last seven days ?

I am looking for a way to get a list of issues that have logged work between a range of dates or in the laste seven days

I have tryed using the updatedDate field but this shows me any kind of updated

I am looking for something similar to this

https://answers.atlassian.com/questions/42077/jira-4-4-search-filter-how-to-find-issues-resolved-in-last-seven-days

Thanks

6 answers

You can use:
updated >= -7d AND timespent is not EMPTY

2 votes
cgauterio Atlassian Team Nov 20, 2014

Hi Mauricio,

Unfortunately, I don't believe that's possible. We have an open improvement being tracked at: https://jira.atlassian.com/browse/JRA-34527

Please add yourself as a watcher to be notified of future updates.

Cheers,

Clarissa.

I will acept this as an answer when the feature gets implemented ;-)

.... which is probably never, since so few people voted for the issue.

Like # people like this

Now we have "worklogDate".

That makes the trick.

Can you give us an example how a query for this would look like?

Like # people like this

Yes! Try this:

worklogDate > -7d

or

worklogDate >= "2021/03/29" and worklogDate <= "2021/04/05"

Like Xingchen likes this
mkrefting I'm New Here May 12, 2021

I have the same issue, that is very helpful, thank you. I noticed though when I tried it that the tickets on the results page show the total time worked, not just the time logged during the range I specified. Is there a way to query by worklogDate and get the results to show you only the time logged during that range?

Like Sandra Kawamoto likes this

Oh, good question. I don't know how to that with a jira filter. I think it is not possible. You would have to use Jira Resp API or Jira Automation to calculate that, adding the values at "timeSpentSeconds" for each worklog on the period. At Jira Automation, you use {worklog.timeSpentSeconds}. Not sure if you would be able to add different worklogs.

Worklog functions at Jira API:

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-issue-worklogs/

It is not possible using only jql filters.

 

However, it is easily achievable when using one of the worklogs related apps from the marketplace:

 

https://marketplace.atlassian.com/search?query=worklogs

We are also very interested in this kind of search:
timespent changed AFTER startOfDay(-7)

But unfortunately the 'timespent' field does not yet support it:
History searches do not support the 'timespent' field.

No, that's right. That simple search helps to find updated issues with time spend, but doesn't mean, that the time spent content was alterated. Maybe the activitity stream gadget and time tracking in a date range can be used.

timespent being not EMPTY does not guarantee that the logged worked also happend in the last 7 days..does it ?

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