Jira DB query to get the Number of Issues Watched by each user

krishna Raviprolu July 15, 2015

I have been using JIRA db for a while to get the information . I am trying to see how effectively is the 'watch this issue' being used. So how do i get the number of issues each user is watching or top 10 watchers this week .Something like that.

I know the table jiraissue would give me the number of watchers but i want how many issues a particular user has watched.

 

1 answer

0 votes
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
July 15, 2015

You'd need to read through nodeassociation for watchers and a user id.  JIRA doesn't really track users adding or removing their watches, it's a flat "watched or not"

Suggest an answer

Log in or Sign up to answer