How I come to know the list of issues in JIRA that the user is watching

Question

Need your help in achieving this.

1. I need to know the list of issues in JIRA, the user is watching.

Example : User A is renamed to User B, now I need to know the list of issues in JIRA where user A is part of watcher's list. Now I need to replace the user A with user B in all these issues. How do I come to know the list of issues, user A is watching.

2. After getting the list of issues, I need to replace user A with user B in all these issues. How do I achieve this.

Balvant Biradar · Answer

please  use below simple JQL.

watcher = "username"

It will list all issues where "username" is watcher

dhiraj kumar_efwr93 · Answer

1.Select Advance Search,

2.watcher = currentUser() // If you want issues you are watching or user for whom you want to watch

Sam Kenny1 · Answer

You can try this SQL:

SELECT *
  FROM [jiraschema].[jiraissue] i
  JOIN [jiraschema].[userassociation] a ON i.[ID] = a.[SINK_NODE_ID]
  WHERE [ASSOCIATION_TYPE] = 'WatchIssue'