Time spent( Work logged) by CurrentUser()

Hi, Is there any way using JQL to find "all issues of currentUser() where timespent/log work? Sometimes work is logged by a user that has not been the assignee of an issue at any stage. We are using the "Time sheet Gadget" to show logged work, but seems it only shows if you are the assignee when work is logged. Our filter used for time sheet gadget is "assignee = currentUser()"

4 answers

1 accepted

Hi Warren,

Why do you use the filter? If you don't use, timesheet gadget will show you all time spent for all isues worked by current user actually.

Thank you.

Thank you, this is correct! Thanks Andriy

Hi Warren,

I just wrote this exact query for an internal requirement smile; glad to share. Assuming you have the most recent version of Jira, the following should work for you...

This Month (remove AND... for all time):

worklogAuthor = currentUser() AND worklogDate >= startOfMonth()

Specific date (replace date with endOfDay() for Today):

worklogAuthor = currentUser() AND worklogDate = "2015/07/10"

Note: Valid date formats include: 'YYYY/MM/DD', 'YYYY-MM-DD', or a period format e.g. '-5d', '4w 2d'.

Hope this helps.

I will have a look at this once we have upgraded our JIRA, We are currently on 6.2 and I have not tested this yet.

Hi Carl,

Many thanks for the above but it also shows work done on another day and adds it for the day it was logged. For e.g.  if I worked on an issue yesterday and today, today's report will show a sum of work logged yesterday and today. Can we not have it showing the time added for a specific day only?

Many thanks for your time and inputs on this one.

Arif

@Carl DiClementi thanks for that JQL.

--

I used the worklogDate to search between two dynamic dates like this:

(worklogDate >= startOfWeek() AND worklogDate <= endOfWeek())

Pop the, "Time Spent" field into the filter to see the total time spent on the item within the time period.

Note: You cannot ask to see multiple issues listed if someone enters time logged on a Monday & Wednesday it will show you the total time spent. If someone really had specific questions, then they will have to open the work log and view when the time was logged.

use (Tempo) time tracking software add-on

0 votes

JQL Tricks plugin (paid) provides this functionality. You can then use the new JQL functions with any gadgets, filters etc.

Hi Jobin, thanks for your input, Is there another way? preferably free way to do this? JQL unfortunately is very limited. Can anyone advise?

Suggest an answer

Log in or Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

3,156 views 13 19
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot