How to find issues that at some point has been assigned to you?

Question

We use Jira extensively in our project, but I often have a hard time finding issues, that I know, I have been working on earlier. Usually, if some case is reported, that seems familiar to something I have been working on in the past, but I don't remember exactly what and when.

Usually, an issue is reported, then our scrum master assigns it to the developer, the developer fixes it (hopefully) and then passes it to the tester (yay, it works!). But then it is no longer assigned to me, and I have a hard finding old issues, that I remember vaguely.

I thought, perhaps it is possible to see the assigned history of an issue, there might be a way to form an advanced search/filter, that finds all issues, that at some time has been assigned to me.

Has anyone done this?

also, this query can be [helpful](http://stackoverflow.com/questions/3518613/jira-find-all-issues-related-to-a-user) — Alex Kulinkovich, May 21 '14 at 16:37

score 302 · Accepted Answer · edited Jan 23 '12 at 09:24

302

This is meanwhile possible by means of the JIRA Query Language (JQL) operator 'WAS', which has been introduced in JIRA 4.3 and extended in JIRA 4.4 to cover assignees and reporters as well, for example:

project = "Angry Nerds" and (assignee was 'johnsmith' or reporter was 'johnsmith')

edited Jan 23 '12 at 09:24

Steffen Opel

63,899
11
192
211

answered Jan 23 '12 at 05:34

Daria Trainor

5,545
4
23
30

6

It appears that this answer was provided significantly after the question was asked, but it should be the accepted answer going forward with newer versions of Jira (4.3 was release March 2011). – Jared May 14 '12 at 13:44
Does the `was` keyword also return a result if the user is the current assignee/reporter? (and say the issue didn't previously have an assignee, or they were the first assigned ever to that issue) – nmz787 Sep 10 '15 at 00:24
and what about ordering by last time I worked on it ? – sashok_bg May 02 '16 at 13:01
2

Did the syntax change? I only find it via `assignee in ("johnsmith")` – Thorsten Niehues Apr 11 '17 at 09:52
2

@nmz787 I tested that the `was` keyword includes currently assigned issues. – Bernard Vander Beken Jul 13 '17 at 12:38

Thomas W · Answer 2 · 2013-11-28T00:50:35.150

38

General-purpose query for whichever 'current user':

assignee was currentUser()

This filter can be conveniently shared & anybody can put it on their dashboard, etc and it will return results specific to them.. Not supported on all old JIRA versions though.

This was my most-requested JIRA feature ever.

edited Nov 28 '13 at 00:50

answered Nov 28 '13 at 00:45

Thomas W

13,940
4
58
76

score 24 · Answer 3 · edited Jun 24 '13 at 11:10

24

Check out JIRA Toolkit plugin - Participants custom field

https://studio.plugins.atlassian.com/wiki/display/JTOOL/JIRA+Toolkit+Plugin

This field allows you to easily track issues that you've "participated in". These are defined to be any issues you've commented on, raised or are the current assignee. See also the [JIRA Extended Participants] plugin.

edited Jun 24 '13 at 11:10

Sam Hasler

12,344
10
72
106

answered Jan 27 '10 at 15:56

Francis Martens

3,458
4
24
26

3

It is now found at https://studio.plugins.atlassian.com/wiki/display/JTOOL/JIRA+Toolkit+Plugin – Michael Piefel Sep 15 '11 at 20:11

warvariuc · Answer 4 · 2015-04-28T17:02:53.050

20

Update

This works without plugins:

assignee was currentUser() OR reporter was currentUser() ORDER BY updated DESC

The original answer

This query worked for me:

Participants = currentUser()

edited Apr 28 '15 at 17:02

answered Sep 07 '12 at 07:02

warvariuc

57,116
41
173
227

1

I tried it but got a message "Field 'Participants' does not exist or you do not have permission to view it." That's with Jira v6.0.6#6105-sha1:9713ad1. – Craig McQueen May 26 '14 at 06:08
@CraigMcQueen, I am not a Jira guru, but I think you need to install [JIRA Toolkit Plugin](https://ecosystem.atlassian.net/wiki/display/JTOOL/JIRA+Toolkit+Plugin) – warvariuc May 26 '14 at 06:17

score 7 · Answer 5 · answered Aug 13 '13 at 05:51

7

try "assignee was username". it would get all tickets been assigned to the user before.

answered Aug 13 '13 at 05:51

Jackie

25,199
6
33
24

score 5 · Answer 6 · answered Jan 27 '10 at 16:00

5

You can find issues by worklog entries directly in the database:

select distinct ji.pkey from jiraissue ji inner join worklog wl on ji.id=wl.issueid where wl.author='some_username';

I agree this should be implemented in the UI though.

answered Jan 27 '10 at 16:00

AJ.

27,586
18
84
94

As a developer, I don't have access directly into the db unfortunaltely. Is it possible to do this through the advanced issues search in some way? – erikric Jan 28 '10 at 08:20
Like i said in my comment, searching on the worklog is not supported yet by Jira. Please vote for it here http://jira.atlassian.com/browse/JRA-12312 – Hugo Palma Jan 28 '10 at 09:24
Is this the best answer for Jira < 4.3? We are stuck with an old version because of certain requirements. – k-den Oct 07 '14 at 23:49

score 4 · Answer 7 · answered Sep 22 '15 at 10:42

For those that will be using JIRA 5+, there is also CHANGED operator that looks at the field changing to specific value within specific time range.

assignee CHANGED TO currentUser() AFTER startOfYear() BEFORE now()

More here: https://confluence.atlassian.com/display/JIRA052/Advanced+Searching#AdvancedSearching-CHANGED

Just another way how to achieve the same result, but might be useful for other cases.

score 3 · Answer 8 · answered Dec 26 '16 at 08:18

was is not supported to assignee field when I tried recently. You must use CHANGED, FROM, TO keywords to filter.

I'm using something like this:

project = MindBlowingProject AND (assignee in (currentUser()) OR assignee CHANGED from (currentUser()) OR reporter in (currentUser())) ORDER BY updated DESC

score 2 · Answer 9 · answered Aug 23 '16 at 21:16

So there are 3 scenarios: 1 - I changed it in some way - assignee changed by [UserName], 2 - I changed the status ( closed it, whatever) - OR status changed by [UserName], 3 - I still have it - OR assignee = [UserName]

So the whole query (assuming that the changed statement is allowed is:

assignee changed by [UserName] OR status changed by [UserName] OR assignee = [UserName]

score 0 · Answer 10 · answered May 16 '18 at 13:19

I think the most sensible approach is to search the issue-history. The only thing, that is not logged there, is who accessed the issue (just watching, without changing anything).

But you can't search the ticket-history without database access (as far as I know, please correct me if I'm wrong)

So, to search all issues with "someUserName" in the issuehistory, you have to inner join the table changegroup (and maybe the table changeitem from there).

Example:

select ji.id,issuenum,summary,creator,assignee,ji.created,updated,c.id as histid,c.author from jiraissue ji inner join changegroup c on ji.id=c.issueid where c.author like 'someUserName';

c.id as histid ==> this is the number/id of the entry in the (issue-)"History" tab

Meaning: if there ever was a change by the user "someUserName" it is logged in the History and it will be listet with this query

The following example will just list every disting issue, where the "myusername" was found in the History after the date 20180501:

select distinct ji.id,issuenum,summary,creator,assignee,ji.created,updated,c.author from jiraissue ji inner join changegroup c on ji.id=c.issueid where c.author like 'myusername' and ji.created > '2018-05-01T00:00:00.000';

I annotated the necessary relation here:

score 0 · Answer 11 · answered Nov 04 '19 at 06:50

0

From menu select Tempo->Reports

Select date-range

and you should see report.

answered Nov 04 '19 at 06:50

Vijay

2,021
4
24
33

Neha Pal · Answer 12 · 2020-01-28T11:44:16.790

-1

I tried the below SQL query and it gives data of all the issues and all the assignees that were ever assigned to an issue. Any change in the assignee for any issue is captured by below query:

select distinct
p.pkey +'-'+cast(ji.issuenum as varchar(max)),
ji.SUMMARY,
cast(ci.OLDSTRING as nvarchar(max)) as 'Old value',
cast(ci.NEWSTRING as nvarchar(max)) as 'New value'
from
jiraissue ji
join project p on p.id = ji.PROJECT
join changegroup cg on cg.issueid = ji.id
join changeitem ci on ci.groupid = cg.id and FIELD = 'assignee'

Anyone looking for the query would find this useful : )

-Neha 'D' Pal

edited Jan 28 '20 at 11:44

answered Jan 28 '20 at 09:12

Neha Pal

1
1

You don't want to explain each column name, each table name, what does it do? You don't? – Aksen P Jan 28 '20 at 09:21

How to find issues that at some point has been assigned to you?

12 Answers12

Linked

Related