nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get worklogs of a user from jql search

Hasitha Weerasi

Hi all,

I'm trying to get all worklogs of a user on a specific date from jql search.

My problem is to find what are the worklogs that are updated from a particular user on a specific date.

is it possible to do that? or is there any other ways of getting that?

I'm using JIRA 4.3.3

Accepted answers

All comments

Treethawat Thanawachiramate

Have you ever checked this page: https://answers.atlassian.com/questions/47652

Cheers !

Filip Pokorny

To put things up to date, with latest Jira it is simple and without any plugins. JQL:

worklogAuthor = fpokorny && worklogDate = "2018-07-26"

Haris Psarropoulos

Hello Filip,

Do you know whether there is currently a problem with the worklogAuthor attribute? When I use: worklogDate >= startOfMonth()

I get results normally. But if use this:

worklogDate >= startOfMonth() and worklogAuthor = XYZ

where XYZ is a user that has logged work from the start of month, I get no results...

Thank you for your time

Filip Pokorny

Hi, Haris

I just tested and I I've got the right results (no issue). Used exactly the query you mentioned:

worklogDate >= startOfMonth() and worklogAuthor = username

How about a workaround to query an assignee instead?

worklogDate >= startOfMonth() and assignee = evoinea2

In my team, we've got always one person on one issue policy so the assignee is actually more relevant, than worklogAuthor: Sometimes, the product manager or the scrum master log and edit the worklog for other team members.

Haris Psarropoulos

Thank you for the fast response Filip, it seems that I have come across a permissions issue as the same filter in one project works, but in another project (Service Desk project) does not work. I have opened a ticket to atlassian to get some feedback on which permission is missing as whatever try I made had no effect. I will post the outcome of the discussion with atlassian support here for everyone's reference.

Patrick Michaelsen

Hi everyone. This doesn't exactly solve my use case. I'd like to sum all work for a given user on a given day. e.g, work logged yesterday:

project = MAG AND worklogAuthor = currentUser() AND worklogDate = -1d

This returns all issues which this user worked on. The time logged column on this table is not useful to because it contains all time logged by any user for that issue.

I find it hard to believe this feature is not built in somewhere. It seems like a very useful metric to be able to see how much time each user is logging.

Andrei Pisklenov _Actonic_

Hi @Patrick Michaelsen ,

This app may solve your issue https://marketplace.atlassian.com/apps/1216997/worklog-simple-report?hosting=server&tab=overview. It has options to group results by users.

Srinivasan Nambi

Hi Patrick,
Were you able to find a resolution to this ?

I am facing similar issue. I'm trying to retrieve the time spent by different users on an issue key # but the results of "Time Spent" and "Sigma Time Spent" are the same which is a cumulative total of time logged by *ALL* users to that issue.

Thanks,

Srini

Joey Klein_0ok27t

Im trying to do the same any luck ?

data data

Jira has absolut no possibility to get worklogs. The only thing you can search for in Jira are issues. And that is the main misunderstanding of this question and the comments.

What you get are issues. When you filter by worklogDate, you get issues which fits. Nothing more. This issues can also have worklogs with different worklogDates.

In Jira you can not search for worklogs. So if you display the worklog total time of an issue in a column of the search result, you see the properties of the issue. This has nothing to do with the constraints in the search query.

Thorsten Letschert _Decadis AG_

Hi @data data ,

If you're interested in 'the worklog-level', I'd kindly recommend evaluating xPort (see https://marketplace.atlassian.com/apps/1215632/xport-custom-worklog-export-for-jira?hosting=server) since it might provide the granularity needed here. I'm with you all the way that there's no such feature within Jira's default capabilities.

Cheers
Thorsten

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-development

rest-api

worklog