Creates, modifies, deletes, and queries the available users in Jira.

Table-Specific Information

SELECT

The component applies filters server-side only when supported for the specific column and operator, as documented in the Columns section. All other filters are processed client-side.

Jira Cloud

The Jira Cloud API has no support for filtering by DisplayName and EmailAddress. These filters are processed client-side.

The only server-side supported filter is filtering by AccountId.

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

SELECT * FROM Users WHERE AccountId = '712020:fcd95543-59da-42bc-a0f2-4ab4265f07d4';

Jira Data Center

The Jira Data Center API supports filtering by DisplayName and EmailAddress.

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

SELECT * FROM Users WHERE DisplayName = 'JohnDoe';
SELECT * FROM Users WHERE EmailAddress = '[email protected]';

Filtering by Key is also supported server-side.

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

SELECT * FROM Users WHERE Key = 'JIRAUSER10472';

NOTE: In Jira Data Center version 10, due to an API limitation, it is not possible to retrieve more than the first 100 users returned by the Jira Data Center API.

INSERT

Insert a user by specifying the EmailAddress column.

INSERT INTO Users(EmailAddress) VALUES ('[email protected]');

UPDATE

Update a user by specifying the Key when connected to a Data Center instance.

UPDATE Users SET DisplayName = 'TestInsertUpdated' WHERE Key = 'USR1';

NOTE: This statement is supported only for Jira Data Center instances.

DELETE

Delete a user by specifying the Key when connected to a Data Center instance, or the AccountId when connected to a Cloud instance.

DELETE FROM Users WHERE Key = 'USR1';
DELETE FROM Users WHERE AccountId = 'USR1';

Columns

Name	Type	ReadOnly	References	SupportedOperators	Platform	Description
AccountId [KEY]	String	True		=	Cloud	The accountId of the user, which uniquely identifies the user across all Atlassian products.
Key [KEY]	String	True			Server	The key of the user.
Name	String	False			Server	The name of the user.
DisplayName	String	False		=	Common	The display name of the user.
EmailAddress	String	False		=	Common	The email address of the user.
Active	Bool	True			Common	Indicates whether the user is active.
TimeZone	String	True			Common	The time zone specified in the user's profile.
Locale	String	True			Common	The locale of the user.
AccountType	String	False			Server	The account type of the user.
Products	String	False			Server	A delimited string of Jira products to which the user has access, for example, jira-core,jira-servicedesk,jira-product-discovery,jira-software.