Manages the available issue watchers in Jira. Supports querying, inserting, and deleting watchers.

Table-Specific Information

SELECT

The connector uses the Jira API to process filters based on the IssueId and IssueKey columns. The connector processes all other filters client-side.

You must specify an IssueId or IssueKey to retrieve results.

For example, the following queries are processed server-side:

SELECT * FROM Watchers WHERE IssueId = '10100';
SELECT * FROM Watchers WHERE IssueKey = 'PRJ-1';

INSERT

Adds a new watcher to an existing issue.

Jira Cloud

To add a new watcher to a specific issue, you must specify the AccountId of the user and either the IssueId or IssueKey of the issue.

INSERT INTO Watchers (IssueId, AccountId) VALUES (19393, '63acbf336f068efec8f6e0c3');
INSERT INTO Watchers (IssueKey, AccountId) VALUES ('CD-352', '63acbf336f068efec8f6e0c3');

Jira Data Center

To add a new watcher to a specific issue, you must specify the Name of the user and either the IssueId or IssueKey of the issue.

INSERT INTO Watchers (IssueId, Name) VALUES (19393, 'CDataUser');
INSERT INTO Watchers (IssueKey, Name) VALUES ('CD-352', 'CDataUser');

DELETE

Removes a watcher from an existing issue.

Jira Cloud

To remove a watcher from a specific issue, you must specify the AccountId of the user and either the IssueId or IssueKey of the issue.

DELETE FROM Watchers WHERE IssueId = 19393 AND AccountId = '63acbf336f068efec8f6e0c3';
DELETE FROM Watchers WHERE IssueKey = 'CD-352' AND AccountId = '63acbf336f068efec8f6e0c3';

Jira Data Center

To remove a watcher from a specific issue, you must specify the Name of the user and either the IssueId or IssueKey of the issue.

DELETE FROM Watchers WHERE IssueId = 19393 AND Name = 'CDataUser';
DELETE FROM Watchers WHERE IssueKey = 'CD-352' AND Name = 'CDataUser';

Columns

Name	Type	ReadOnly	References	SupportedOperators	Platform	Description
DisplayName	String	True			Common	The displayed name of the watcher.
EmailAddress	String	True			Common	The email address of the watcher.
AccountId [KEY]	String	False	Users.AccountId		Cloud	The accountId of the watcher.
Key [KEY]	String	True			Server	The account key of the watcher.
Name	String	False			Server	The name of the watcher.
IssueId [KEY]	String	False		=,EMP_EQ	Common	The issue ID of the watcher.
IssueKey	String	False		=,EMP_EQ	Common	The issue key of the watcher.