How do I access individual time logged entries?

[Carol Borstnik]

I'm trying to access the time logged in an individual log entry (see screenshot). The query grabs the correct items, but the Time Spent column gives me the TOTAL time spent rather than the time on that specific entry.  

Query: issuetype =Sub-task and worklogAuthor = currentUser() and worklogdate >= startOfMonth(-1)

[Svitlana Samotis _Reliex_]

Hi @Carol Borstnik

It looks like you need a more detailed breakdown of time logged in individual entries. If you are considering third-party solutions, ActivityTimeline can help. 

With ActivityTimeline, you can easily access the time logged for each specific log entry, giving you a clearer understanding of where and how time is being spent. 

If this sounds like something that could benefit your workflow, please feel free to get in touch with our team at support@reliex.com 

Svitlana, ActivityTimeline team 

[Gracjan Wesołowski _HeroCoders_]

Hi @Carol Borstnik 

You might consider using time-tracking apps that in most cases have a customizable report of tracked time on issues.

I can recommend our Clockwork Automated Time Tracking & Timesheets Pro, or Free app which offers you the possibility to review timesheets and create reports that can be configured in various ways using break-down and filtering options.

Using timesheets, you can create a report and filter it based on several options including labels, or other fields. You can choose a range for a whole year and break down the data by chosen fields. This information can be also exported to Excel files.

We have recently also developed a Team feature that allows you to create Teams which can be used in timesheet filters and breakdowns. When a team is selected for a timesheet/report, all users in the team will be included in the report even if they do not have any worklogs for the selected timeframe.

Please find below the sample of how the timesheet looks like:

If you have any questions you can contact us via our help center.

Cheers!

Gracjan

[Deniz Oğuz - The Starware]

Hi @Carol Borstnik 

JQL returns issues, not worklogs. You can use worklog related clauses in JQL, such as worklogAuthor or others but at the end, JQL will return the issues. To see worklog level detailed information or other reports, you will need a time tracking app from the marketplace. 

Our WorklogPRO app has a separate window for worklogs on the issue view which allows you to inspect each worklog and change them if you have permission. 

[Amay Purohit_RVS]

Hi @Carol Borstnik  

If you would be interested in a mktplace app to get this data, you can try the add-on we have developed. You can easily view time entries for multiple issues day wise in a single view. And  with the ability to export to a CSV as well. 

Agile Tools

The app allows to filter/Categorize/Group By your worklogs data and a timesheet view too to track individual time spent. 

Plus the app has multiple other useful Project management features .

Disclaimer : I work for the vendor who built this app

[Trudy Claspill]

Hello @Carol Borstnik 

Queries are intended to retrieve issues that match the conditions. They are not intended to retrieve just sub-attributes of issues, such as worklog entries or comments.

Jira does not provide any native methods to retrieve just worklog entries in the UI. You could potentially design something to do that with the API, or through an Automation Rule, depending on what you want to do with the output.

Additionally the Time Spent field will always contain the total time in all worklogs associated with the field.

Jira also does not provide any methods to get time reports that sum up the time logged by a specific user during a specific time period.

If you want to sum time for an issue from only specific worklogs, that will require a third party app.

There are several apps that provide time reporting options. Here is a search from the Atlassian Marketplace to help you get started.

https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=time%20report