JQL query to fetch all the issues, time log on day to day basis for the members of a project.

Question

Hi,

JDL query to fetch the Worklog author, time log, issue on the day to day basis for the project management purposes.

I used this query,

worklogAuthor in (membersOf("NFR")) AND worklogDate >= "2023/02/22" AND worklogDate <= "2023/02/23"

But its not showing the user who all are logged on daily basis.

So im requesting all to provide the query to fetch the result for each day from a particular window.

Thanks.

Naveen Kumar Sakthivel · Answer

Thanks @vikastak

vikastak · Answer

Hi @Naveen Kumar Sakthivel ,

You can use the below JQL for getting the worklog done on specific date

worklogAuthor in (membersOf("NFR")) and worklogDate >= startOfDay(-1) and worklogDate <= endOfDay(-1)

You can use startOfDay, startOfWeek, startOfMonth for specific day, week or Month data.

I hope this solves your problems.

Madhu_RVS · Answer

Hi @Naveen Kumar Sakthivel ,

Welcome to the Community !!!

If you would be interested in a mktplace app to get this data, you can try out our add-on

Worklogs Time Reports

The app provides the following features.

* Worklogs Report :* Create reports for time entered by your team
* Filter/Categorize/Group By your worklogs data

* Timesheets : View/Enter time spent for multiple issues and multiple days from a single screen
* Dashboard gadgets

Disclaimer : I work for the vendor who built this app