JIRA: find all my logged work for last week

Question

How would I create a JIRA filter that lists all of the issues on which I've logged time? I can then apply this to the activity stream.

score 37 · Answer 1 · edited Dec 02 '16 at 12:50

37

Use advance searching via JQL:

worklogAuthor = currentUser() 
                AND worklogDate >= "2016/12/01" 
                AND worklogDate <= "2016/12/31"

edited Dec 02 '16 at 12:50

Bojan B

2,091
4
18
26

answered Dec 02 '16 at 10:40

Mahesha Kalpanie

371
3
2

If you indent your code by four spaces it will be automatically formatted, which reads and looks better. – henrycarteruk Dec 02 '16 at 10:54
Does it find issues with workLog items created in these dates among other workLogs? Can it aggregate only workLogs only for these days? – Eugene Lisitsky Apr 26 '17 at 10:07
I couldn't find worklogAuthor field in documentation: https://confluence.atlassian.com/jira063/advanced-searching-fields-reference-683542531.html – Bronek Dec 06 '17 at 18:02
worklogAuthor and worklogDate are only available in JIRA 7+ – Renan Nov 26 '19 at 07:57
Elaborating on this, you can use the same query but for your current week :) `worklogAuthor = currentUser() AND worklogDate >= startOfWeek() AND worklogDate <= endOfWeek()` – Or b Dec 29 '22 at 13:39

score 19 · Accepted Answer · edited Jul 01 '15 at 07:57

19

If you have Script Runner installed, you can use the following query. It will show you the issues only where you have logged work in JIRA.

issueFunction in workLogged("after 2014/09/01 before 2015/01/30 by <USER_NAME>")

Where the dates can be set to the range of the week you want to query, and the USER_NAME can be your username.

Script Runner Documentation

edited Jul 01 '15 at 07:57

SebK

487
4
12

answered Jan 22 '15 at 05:08

Scorypto

306
2
4

3

issueFunction does not seem to exist. – Jeremy Holovacs May 29 '15 at 13:31
You need to have Script Runner installed (free, incredibly useful addon) – SebK Jul 01 '15 at 07:18
You can do this without script runner. See https://stackoverflow.com/a/40930243/1015595. – Big McLargeHuge Jan 11 '18 at 18:12

score 19 · Answer 3 · answered May 26 '17 at 09:52

19

Using JQL you can do something like this and you won't need to update the filter every week.

    worklogAuthor = currentUser() 
AND worklogDate >= startOfWeek(-1w) 
AND worklogDate < startOfWeek()

Source for startOfWeek()

answered May 26 '17 at 09:52

Ronnie

545
6
9

If I type in this query it shows me the green tick but somehow I cannot save the filter. Looks like I cannot execute the query :-( – Sebastian Mar 19 '18 at 07:36

score 0 · Answer 4 · answered Sep 25 '14 at 21:32

Plugins are your answer. Search the marketplace for "Timesheets" if you are using the built in JIRA work logging. Personally, I have had a lot of success with JIRA Timesheet Reports and Gadgets.

If you are still wanting a JQL plugin to give you back your results OR you are using JIRA cloud, have a look at JQL Pro, it appears to do what you need.

score -1 · Answer 5 · answered Apr 18 '14 at 20:04

-1

What worklogs are you using? Sadly, it is not possible with the JQL. You might get lucky if you are using some plugins such as Tempo as they might have some internal reports.

answered Apr 18 '14 at 20:04

Nikhil Gupta

1,708
1
23
38

JIRA: find all my logged work for last week

5 Answers5

Linked