40

In JIRA, how do a find all issues related to a user, across all projects.

A simple query search yields only full text results. i.e. only issues where the name is mentioned and not if the name has been assigned, has reported, has been cc’d etc.

My intention here is to find tickets related to me for stock accounting.

I'm using JIRA 3.13.

Alex Kulinkovich
  • 4,408
  • 15
  • 46
  • 50
Quintin Par
  • 15,862
  • 27
  • 93
  • 146

8 Answers8

73
assignee = currentUser() OR assignee was currentUser() OR reporter = currentUser()

This will suffice the query

Avrajit Roy
  • 3,233
  • 1
  • 13
  • 25
Edson Medina
  • 9,862
  • 3
  • 40
  • 51
  • 6
    Sorry, I am new to JIRA. I'm looking at the web interface and I have no idea how I would make this work. Is there some place where I c+p this? Could you provide some additional instructions? Your answer seems magical and mystical. I've whispered these incantations to the server but no luck so far – MedicineMan Feb 14 '13 at 22:20
  • 1
    @MedicineMan When seeing a list of issues, press "Edit" on the left sidebar to edit the query. – Edson Medina Mar 04 '13 at 09:56
  • Not really sure how that differs from "find all issues related to a user", certainly if a user is a watcher on a ticket, then they are related to that ticket, no? – Adam Parkin Jun 14 '16 at 15:49
  • Go to search page by browsing to `/browse` – Pavel Petrov Mar 19 '21 at 10:55
  • Add `OR worklogAuthor = currentUser()` for issues you logged on but was never assigned to – DFSFOT Apr 06 '22 at 07:38
9

Just had the same 'stock accounting' use case: If you like to get an overview of the issues where you were involved to, just go to the profile page of your user, and hit 'Activity'. All tickets you had been working on are displayed.

This seems to be an alternative for all who are also not able to do a query like

assignee was currentUser()

because their Jira does not support history searches on that field (like ours here).

mechko
  • 93
  • 1
  • 2
5

Like Greg mentioned, you can use the "FIND ISSUES" -option. By default, you can only do searches by the issue reporter or by the assignee. But if your Jira installation has the Jira Toolkit plugin installed, you can run a search by participant. This is a good feature if you need to find the issues which you have helped to resolve, but aren't anymore assigned to you.

Mikael Koskinen
  • 12,306
  • 5
  • 48
  • 63
5

Click on Issues on the top, click New on the left bar.

Now, choose the reporter and assignee. Then switch to Advanced search.

Then you can change the AND to an OR and do the search.

e.g. 

assignee = currentUser() OR reporter = currentUser()

(it would have been AND by default)

David d C e Freitas
  • 7,481
  • 4
  • 58
  • 67
4

In JIRA, I need to find really all issues related to a user (me) including comments, assignee, reporter, watcher and status updates.

I've used filters with JQL and next query: 

status changed BY currentUser() OR reporter = currentUser() 
OR watcher in (currentUser()) OR assignee = currentUser() 
OR assignee was currentUser() OR commentedByUser = currentUser() 
ORDER BY updated DESC
  1. Open filter page:

JIRA Filter

  1. Switch to JQL Switch to JQL button

  2. Enter query and click Search button. enter image description here

Alex Kulinkovich
  • 4,408
  • 15
  • 46
  • 50
1

You should be able to use the "FIND ISSUES" option across the top bar, select "New" to create a new filter (which by default spans all projects), and select your name from the relevant "Issue Attributes" dropdown boxes.

Greg Hewgill
  • 951,095
  • 183
  • 1,149
  • 1,285
  • 1
    The problem with this kind is that it’s an AND condition and not OR. I can’t search for “Reporter” OR “Assignee” OR “CC” .. – Cherian Aug 19 '10 at 05:19
0

If you need a hammer:

watcher = currentUser() OR assignee = currentUser() OR assignee was currentUser() OR creator = currentUser() OR reporter = currentUser() OR comment ~ currentUser() OR text ~ currentUser() OR summary ~ currentUser() OR description ~ currentUser() ORDER BY updated DESC

You could limit to some days:

updated > -365d AND (watcher = currentUser() OR assignee = currentUser() OR assignee was currentUser() OR creator = currentUser() OR reporter = currentUser() OR comment ~ currentUser() OR text ~ currentUser() OR summary ~ currentUser() OR description ~ currentUser()) ORDER BY updated DESC

gavenkoa
  • 45,285
  • 19
  • 251
  • 303
-2

Open the JIRA web application/site in your browser and navigate to Issues (in header) > Search for issues, then enter your search criteria.

tedi
  • 6,350
  • 5
  • 52
  • 67