Listing jira issues where user is a watcher

[Kota Sreenivasa Shravana Kumar]

Looking for the following things.

1. How to list the JIRA issues where the user is a watcher ?

2. How to list users who are watching issues in a project ?

Thanks

[Udo Brand · Accepted solution]

the first you can do with

watcher = <USER>

the second you can't since you can search only for issues

[Matthew Morgan]

Unfortunately this only works if you only have one watcher. If there's more than one watcher it will omit the issue you are watching.

[Jean-Christophe Gonzales]

At least it works fine with Jira server v8.2.4, even though several users are registred as watchers on tickets :

[Renjith Pillai]

If you access to database you can use the following SQL:

1)

select * from jiraissue where id in (select SINK_NODE_ID from userassociation where ASSOCIATION_TYPE = 'WatchIssue' and SOURCE_NAME = 'username');

2)

select distinct(SOURCE_NAME) from userassociation where SINK_NODE_ID in (select id from jiraissue where project = (select id from project where pkey='project_key'));

[P_D_ Foerster]

Thank you for pointing that out!

I used the first query to find watches for an user who doesn't exist anymore but his watches cause problems with project automation. 

With this query I could delete these watches and after a reindexing the problem was gone.