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

[Mauricio Gracia]

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

[Jose M.]

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

[cgauterio]

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.

[Mauricio Gracia]

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

[David Skreiner]

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

[Sandra Kawamoto]

Now we have "worklogDate".

[Chris]

That makes the trick.

[Thomas Kekeisen]

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

[Sandra Kawamoto]

Yes! Try this:

worklogDate > -7d

or

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

[mkrefting]

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?

[Sandra Kawamoto]

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/

[Jakub Sławiński]

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

[Jose M.]

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.

[Jose M.]

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.

[Mauricio Gracia]

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