Returns the available Users in Jira and their issues.

View-Specific Information

SELECT

The add-in uses the Jira API to process filters based on the AccountId (Cloud), Name (Data Center), DisplayName, EmailAddress, and IssueKey columns. The add-in processes all other filters client-side.

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

SELECT * FROM IssuesUsers WHERE IssueKey = 'PROJ-123';
SELECT * FROM IssuesUsers WHERE AccountId = '5b10a2844c20165700ede21g';

Columns

Name	Type	References	SupportedOperators	Platform	Description
AccountId [KEY]	String	Users.AccountId	=	Cloud	The accountId of the user, which uniquely identifies the user across all Atlassian products.
Key [KEY]	String	Users.Key		Server	The key of the user.
IssueKey [KEY]	String	Issues.Key	=	Common	The key of the issue.
Name	String		=	Server	The name of the user.
DisplayName	String		=	Common	The display name of the user.
EmailAddress	String		=	Common	The email address of the user.
Active	Bool			Cloud	Indicates whether the user is active.
Deleted	Bool			Server	Indicates whether the user is deleted.
TimeZone	String			Common	The time zone specified in the user's profile.
Locale	String			Common	The locale of the user.
AccountType	String			Cloud	The account type of the user.