Returns the available users in Jira and their projects.

View-Specific Information

SELECT

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

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

SELECT * FROM ProjectsUsers WHERE ProjectKey = 'PROJ';
SELECT * FROM ProjectsUsers 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.
ProjectKey [KEY]	String	Projects.Key	=	Common	The key of the project.
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.