See List of Work Log Entries

Question

Using Jira Cloud and the Time Reports plugin, we're trying to find a report that shows all work log entries (the actual work log, not the time worked, or the dates, just the text). We'd like to see this report for all projects at once (not filtered by project and not filtered by user, although these filters would be helpful).

An example might be something like this:

Work Log Date | Project | Log Text
===========================================================================
2019-05-16    | SAL-35  | Implemented contact us form
---------------------------------------------------------------------------
2019-05-16    | SAL-63  | Changed header to better match designs
---------------------------------------------------------------------------
2019-05-16    | SAL-44  | Fixed bug

It might also be interesting to see the User who made the work log but it is not essential.

All of the other community questions seem to be directed at writing JQL, which we can do, but don't know where to see the results (is there a Jira console somewhere where we can enter and execute JQL on the fly?). Other community questions seem to ask the same thing but when we try the suggestions they either don't work or don't produce the results we're looking for (the actual work log text).

Any help would be greatly appreciated.

Ted Stresen-Reuter · Answer

Hi Petter and thanks for the reply.

the actual work log, not the time worked, or the dates, just the text

We're only looking for the worklog messages, not the amount. I know that sounds strange but we're doing an analysis on what makes a good worklog entry and what doesn't. We are looking for a large sample to do a proper analysis.

I've tried the Time Entry report and although I'm certain I have work log entries for specific projects and tasks, they aren't showing up in the report. I think it's a bug but work logs do show up for other tasks. It's very strange… Maybe we need to update our version of the plugin? Any idea how we can check or how to do that?

Thanks in advance.

Petter Gonçalves · Answer

Hello Ted,

Thank you for reaching out.

Although JQL Queries return only issues and not worklog entries, you can indeed return a list of issues together with the time spent in each one, however, you can only return the sum of all the worklog entries in each Issue.

If that would work for you, you just need to perform the following steps:

1 - Navigate to your JIRA Application > Click to search for issues in the left menu (Magnifying glass) > Advanced search for issues

2 - In the filter bar, create a query to return the issues you want

3 - Click to display the filter in list View:

4 - Add the column Time Spent to your filter

Now, if you want to return a list of all worklog entries below each issue, you can use the time entry report provided by the Time Reports plugin:

Let me know if you have any questions.