Time Sheet Report by Rich Filter

[Javad]

Hello all,

I have a question about using rich filters. I want to create a table to show how much time is spent on each task for a selected period of time. As an example, when I choose user1 and period 14-day by rich filter controller, then the table is filtered to show all the tasks of user1 that he/she has logged during the last 14 days and show how much time is logged during the last 14 days for each task. I've already done it by the "Rich Filter Result" gadget but it shows all the time spent on the tasks, not the last 14 days logs.

[Walter Buggenhout]

Hi @Javad and welcome to the Community!

Your observation is absolutely correct. The behaviour you see is because the underlying search in Jira always returns issues. Even though JQL does indeed allow you to search for issues that have worklogs at, before or after certain dates, that search will always return those issues, but also the time spent on those issues outside your search criteria.

If you want to do proper reporting on worklogs, this is an area where you would benefit greatly from adding a marketplace app to your instance that focuses on this area. Both internally and as a Solution Partner, we usually work with Tempo Timesheets for this, as it does not only allow you to do proper reporting, but it also has a lot of process features to help you streamline time tracking across your organisation. But if you check out the marketplace, you'll quickly find out that there are plenty of time tracking and reporting apps that may help you get what you need.

Hope this helps!