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; } } }

Time spent( Work logged) by CurrentUser()

Warren McInnes

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()"

Accepted answers

All comments

Jobin Kuruvilla [Adaptavist]

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

Warren McInnes

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

Andriy Zhdanov

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.

Warren McInnes

Thank you, this is correct! Thanks Andriy

unknown

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 &gt;= 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.

Warren McInnes

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.

Hector David

use (Tempo) time tracking software add-on

Arif Ahmed Khan

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

Benjamin Dains

@[deleted]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.