JIRA - Resolved by me query

Question

How to write query that will select only issues resolved by me.

I have found some old post that says its no possible, but it might have changed.

score 66 · Accepted Answer · edited Sep 11 '14 at 00:51

66

Use next JQL: status was resolved by "username"

edited Sep 11 '14 at 00:51

Petro Semeniuk

6,970
10
42
65

answered Aug 30 '11 at 22:53

CJ Teuben

940
9
12

2

`STATUS was REOPENED and PROJECT in (A, B, C) and STATUS was RESOLVED by "daniel"` works just fine... but is there a way to query something like `STATUS was FIRST RESOLVED by ...`? That's what I'd need... – Daniel Bleisteiner Sep 05 '12 at 14:17
1

Check this out I'm not sure if this is something that might be of assistance to you or not: https://confluence.atlassian.com/display/JIRAKB/How+to+Capture+the+Initial+Resolution+Date – CJ Teuben Sep 16 '12 at 02:37
project = prohjectname AND status was "Resolved" by username and resolutiondate >= '2014/01/08' and its variants exists in jql now i am not sure whether they existed at the time question was asked. – no name Sep 03 '14 at 07:27
Shouldn't it be ```status changed to Resolved by "daniel"```? 'Changed by' works for me instead of 'was'. – Hubbitus Feb 16 '15 at 14:59

score 38 · Answer 2 · answered Sep 27 '11 at 21:47

38

In 4.4 this seems to work:

status was "Resolved" by currentUser()

More details can be found here.

answered Sep 27 '11 at 21:47

Dave Andersen

5,337
3
30
29

score 8 · Answer 3 · answered Dec 27 '13 at 22:58

The answer most often given is to use JQL for something like

status was Resolved BY currentUser()

While all fine and good, this will give you back all the issues that you have ever resolved. That is, if you resolved issue FOO-1966 and then it got reopened and someone else resolved it again it is still an issue that was resolved by you.

Here's a better way to do this in JIRA 6 and later (including JIRA onDemand).

Create a custom field called "Resolver". Make it a person field but do not add it to any forms (unless you really want to).
Edit your workflow and add a post function to the resolve issue transition in your workflow. Make the action "Update custom field" and set the Resolver to %%CURRENT_USER%%.
Publish your workflow.

Now whenever someone resolves an issue using that workflow, the Resolver field will get set to the current user. Now the Resolver field is semantically "last resolved by".

As an added bonus, you can use the value in the Resolver field to reassign issues back to the person who resolved them when they get reopened. I'll leave this as an exercise to the reader. :-)

score 4 · Answer 4 · answered Aug 30 '11 at 07:48

4

You can use this JQL query:

 "Resolved by" = currentUser()

(I just verified this in v4.1.2#531 on a standalone version)

There is also a plug in you can use in older versions: https://studio.plugins.atlassian.com/wiki/display/JQLT/Home

answered Aug 30 '11 at 07:48

DarylChymko

1,048
1
8
11

1

`Resolved by` is this custom field or out-of-the-box? I ask because in mine 4.2.1#b588 there seems to be no such field (I tried both simple and advanced search) – gnat Aug 30 '11 at 11:54
I see thanks. `cf[10038}` - here, `cf` seems to denote [custom field](http://confluence.atlassian.com/display/JIRA/Adding+a+Custom+Field) indeed – gnat Aug 31 '11 at 07:03
1

I am having `JIRA (v4.1.2#531)` but this query does not work for me. Says **Field 'Resolved by' does not exist.** – Kuldeep Jain Feb 25 '14 at 05:55
@KuldeepJain Same error message with JIRA v6.3.10 when this query is run. – Andreas Oct 07 '15 at 12:59

score 2 · Answer 5 · edited May 10 '12 at 20:22

2

None of the above worked for me on JIRA (v4.1.2#531)

However, his works:

"Resource" = currentUser() AND (status = Fixed OR status = Closed OR status = "No Change Required") ORDER BY updated

edited May 10 '12 at 20:22

Kevin Bedell

13,254
10
78
114

answered May 09 '12 at 19:55

Vadim Pesochinskiy

21
1

score 1 · Answer 6 · answered Aug 09 '12 at 10:32

1

You can use the WAS operator:

JIRA - Advanced Searching : "The "WAS" operator is used to find issues that currently have, or previously had, the specified value for the specified field"

Example: status WAS "Resolved" BY currentUser()

answered Aug 09 '12 at 10:32

alexfdz

435
4
5

score 1 · Answer 7 · answered Nov 14 '14 at 15:45

1

For JIRA v6.3.4, this worked for me:

"Resolved By" = currentUser()

answered Nov 14 '14 at 15:45

samerghelou

11
1

score 0 · Answer 8 · answered Sep 25 '12 at 06:23

0

None of the above solutions worked for me. I started adding a label to all my issues to resolved_by_kishore, then in advanced search, I'm using lables=resolved_by_kishore. It's working fine.

answered Sep 25 '12 at 06:23

luckykrrish

128
6

What version of Jira are you using? – Logan Jan 23 '14 at 19:13
It was old version. After we migrated to new version, these was and is are working. – luckykrrish Feb 11 '14 at 13:29

score 0 · Answer 9 · answered Sep 03 '14 at 07:28

project = prohjectname AND status was "Resolved" by username and resolutiondate >= '2014/01/08'

and its variants exists in jql now i am not sure whether they existed at the time question was asked.

i am adding this answer so that if anyone comes here can find the answer

score 0 · Answer 10 · answered Nov 28 '17 at 09:19

I guess you can use this

status in (resolved) AND component = COMPONENT_NAME AND assignee in (currentUser()) AND resolved > -1d

but the new thing here resolved > -1d this to get the issues that are resolved me in this day

resourses: https://community.atlassian.com/t5/Jira-questions/JIRA-4-4-search-filter-how-to-find-issues-resolved-in-last-seven/qaq-p/77326

score 0 · Answer 11 · answered May 12 '22 at 19:47

0

The values used in Status can vary (e.g. Resolved, Closed, Done, ...) so it is not reliable to use.

Instead, use resolution:

resolution changed from EMPTY by currentUser()

answered May 12 '22 at 19:47

sean

47
6

gnat · Answer 12 · 2011-08-31T07:08:00.470

0

As far as I can tell, search for resolved by me and more generally, for status changes, is not possible until at least JIRA 4.2.1 (the version I'm using now).

Search and JQL enhancements outlined in 4.3 and 4.4 release notes look like the move in the right direction (WAS operator) but I'm not holding my breath.

edited Aug 31 '11 at 07:08

answered Aug 30 '11 at 07:39

gnat

6,213
108
53
73

score -1 · Answer 13 · edited Mar 26 '14 at 19:17

-1

Using = EMPTY seems to work for searching for empty custom fields with newer versions of Jira

edited Mar 26 '14 at 19:17

Beryllium

12,808
10
56
86

answered Mar 26 '14 at 18:58

Draven

1

Please check if I have formatted the relevant query correctly (BTW I have not downvoted the answer) – Beryllium Mar 26 '14 at 19:19

JIRA - Resolved by me query

13 Answers13

Linked