Obtain worklog information with out select ALL fields

[snwatts6]

 Is there no way to get this worklog detail with out selecting ALL fields on a query. I want to be able to run a query, and select certain columns from the list, along with the worklog details, but do not want to sift through all the extra fields. I see this isn't an option to select as a seprate column? Is there another way to get this information using JQL maybe?    

The clarify this is the hours when you select log work,  Not time spent.  I understand these can be different, so want to get the hours people enter by using the "log work" option

[Gökçe Karaduman-The Starware]

Hi @snwatts6 ,

Worklog details (log work hours) typically don’t appear directly in Jira’s standard issue navigator view, mainly because an issue can have multiple worklog entries. For this reason, there usually isn’t a dedicated “worklog hours” column among the standard fields.

 Using the Jira REST API: The REST API is the most flexible way to retrieve worklog details. With the API, you can fetch the worklogs of specific issues and extract only the fields you need (for example, just the hours logged or the users).

Example API request:

 GET /rest/api/3/issue/{issueIdOrKey}/worklog

The JSON response contains the worklog hours and user information.

Third-party add-ons / Apps: If you're open to using third-party applications, there are add-ons available on the Jira Marketplace, like WorklogPRO, which make it easier to report worklog details and allow you to select the columns you want..

Thanks to the timesheet view provided by WorklogPRO, you can see how many hours users have logged on each day within the relevant period. Additionally, by clicking on a specific cell, you can access detailed information about those worklog entries.

You can use the JQL queries you’ve saved in Jira within the timesheet filters to view worklog hours for the desired issues. You can also group and analyze these details by user, project, team, and other criteria.

Disclaimer: I work for the vendor who developed this application.

[snwatts6]

Thank you.  I will have look into this.  I have never worked with a rest API, so is there is something you can share that may help learn how to incorporate this into Jira ?

[Gökçe Karaduman-The Starware]

Hi,

Since you're new to REST APIs, I'd recommend starting directly with Jira’s own REST API documentation. It's designed for both developers and non-developers, and it gives clear examples on how to interact with Jira programmatically.

For example, if you want to get worklog details for a specific issue, you can use this endpoint: GET /rest/api/3/issue/{issueKey}/worklog

The response will include all worklog entries, including who logged the time and how many hours were entered.

A great way to test these APIs — even without writing any code — is using a tool like Postman. You can enter the request, authenticate using your Jira email and API token, and view the data in a readable format.

[Rahul_RVS]

Hi @snwatts6 

For detailed time tracking reports if you would be interested to explore a mktplace app, pls take a look at

Worklogs Time Tracking in Jira & Timesheets

With this add-on, you can easily add the worklog authors and time tracking reports as a dashboard gadget. Main features of the app -

• Create time reports in real time by grouping & categorizing data with aggregation
• Prepare your reports based on Project/Sprint/Issue Type/Assignees and various other filters
• Group your data to build more meaningful reports
• CSV Export
• Dashboard gadget
• Enter Time Spent for multiple issues from Timesheet screen. With Calendar view and Board view

The app is free upto 10 users.

(Disclaimer: I am part of the app development team)

[snwatts6]

Thank you, I will see I can get the add-on installed 

[Anton from JetHeads_io]

Hi, @snwatts6! 👋

You’re correct — Jira’s native JQL can’t return individual worklog entries as separate columns. What you get in issue queries are fields like “Original estimate,” “Remaining estimate,” and the accumulated “Time spent.” But the detailed worklogs (the actual entries people make in the “Log work” dialog, with hours, date, author, and comment) aren’t exposed in JQL results.

That’s why most teams use a Marketplace app for this. For example, JetTime gives you:

• A Worklog Report that shows every entry with user, date, hours, and comment — fully filterable by project, issue, sprint, or JQL.

• Flexible export so you only include the fields you care about, instead of sifting through all Jira columns.

• Real transparency into how hours were actually logged, not just the accumulated “time spent.”

Since JetTime is privacy-first and runs fully on Atlassian Forge, all data stays inside Jira Cloud — no external servers involved.

👉 JetTime on the Atlassian Marketplace

— Anton, JetTime founder

[snwatts6]

Awesome.  thanks for the suggestion.