In Jira I would like to know “log Hours” for each day on the active sprint.

[meenu_hooda]

Hi, 

In Jira I would like to know “log Hours” for each day on the active sprint. For ex- one user worked on an issue today and logged his hours as 2 hrs. And then tomorrow again he is logging another 2 hrs on the same issue. So is there any JQL to extract this data day wise. 

I used JQL as : project = "ABC" and Sprint In openSprints() 

But with this JQL, under Time Spent I can see the logged time in total (like 4 hrs for above example). I need to see this day wise (2-2 hours logged for 2 separate days)

[Michael Andolfatto]

Hi @meenu_hooda , welcome to the Community!

The problem with using JQL to do this, is that JQL will always return a set of issues. It is not meant to return components of issues, such as individual worklogs, though this information can be seen on the issue itself in the Activity menu.

Worklogs are retrievable for issues using Jira cloud's API so you could potentially script a solution to export what you need, but many other users commonly use third-party plugins such as Tempo Timesheets for worklog reports which can be accessed within the app itself.

[meenu_hooda]

@Michael Andolfatto 

Thank you for the information. Do you mean I should use ScriptRunner for writing the solution? If yes then could you please help me with that too because I'm new to JIRA and haven't used it before. So, it would be great if you could share the script for me. 

Thank you in advance.

[Rahul_RVS]

Hi @meenu_hooda ,

Welcome to the Community !!!

As mentioned below, you will need and app for this. If you are fine with that, you can try out our add-on

Agile Tools : Epic Tree, Links Tree, Time in Status & Worklogs

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 from a single place
• Dashboard gadgets

 Disclaimer : I work for the vendor who built this app