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

[SNK]

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.

[vikastak]

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.

[SNK]

Thanks @vikastak 

[Madhu_RVS]

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