how to know when/who watcher been added to jira ticket?

Question

Hi All,

I wanted to know who/when the watcher being added to the JIRA ticket, any idea to check it from GUI ? or from DB? Thanks!

unknown · Answer

From the GUI, Click on the "More" button then click "Watchers"

Vasiliy Zverev · Answer

Try using this SQL

select
	userassociation.CREATED
	, userassociation.SOURCE_NAME
	, jiraissue.issuenum
from
	userassociation
	join jiraissue	
		join project	on	jiraissue.PROJECT = project.ID
	on	userassociation.SINK_NODE_ID = jiraissue.ID
	and	userassociation.SINK_NODE_ENTITY = 'Issue'
where
	project.pkey = '' --type projct key here
	and jiraissue.issuenum = 1 -- type issue number here