get spend time in my project between two dates

carlos_marin

Hi,

Is there way with Jira default (no plugins) to get the time spent in my tasks' project between two dates?

Those tasks can have more work logged outside the specified dates.

 

With this filter, the time spent is showing time for all the period, not for the specified worklogDate interval: 

worklogDate >= 2021-03-17 AND worklogDate<= 2021-04-30 AND project = MyProject

 

Thanks in advance!

 

Daniel Ebers

Hi @carlos_marin

the ask is two-fold indeed in your specific case.

For a query the one that Yuliia refined is working okay but if I got you right the ask is for a specific sum in the column which also refers to the from -> to date in the query.

This however is not possible but a long-standing ask in Community.

From this thread there are some approaches and workarounds, some suggest to request data via API or use some App that could be more capable of returning what you are after:

https://community.atlassian.com/t5/Jira-questions/How-to-get-worklogs-of-a-user-from-jql-search/qaq-p/521108

 

I think the most interesting part (at least in terms of an explanation) is:

The only thing you can search for in Jira are issues. And that is the main misunderstanding of this question and the comments.

What you get are issues. When you filter by worklogDate, you get issues which fits. Nothing more. This issues can also have worklogs with different worklogDates.

In Jira you can not search for worklogs. So if you display the worklog total time of an issue in a column of the search result, you see the properties of the issue. This has nothing to do with the constraints in the search query.

After this was said over there an App was recommended. You could check if this would be a suitable option for you.

Regards,
Daniel