Query

[Jo]

We use Tempo Team (server).

I am searching every month for time (worklogs) tracked during last month.

So if the current date is 5th of November, I would like to see all the time spent from 1st of October until 31st of October.

If I execute the same query on the 2nd of December, all time spent from 1ste of November until 30th of November should be displayed.

I am familiar with advanced search, but not with all of the advanced functions.

Thank you for helping.

[Walter Buggenhout]

Hi @Jo,

Is there a reason why you aren't using the built-in functionality of Tempo Timesheets for viewing this information? It has out of the box reporting built-in to show you all you need. Just asking as you say you use Tempo Team ...

If you want a list of all issues with hours logged, you can use the following:

worklogdate >= StartOfMonth(-1) and worklogdate <= EndOfMonth(-1)

Be aware though that this search will get you all issues with time spent during the previous month, but it will also include all time spent from earlier/later dates as well. The reason for this being that JQL searches for issues, not worklogs.