Users
Query the available Users in JIRA.
Select
The adapter will execute filters other than the following client-side within the adapter. The JIRA APIs have limited support for filtering the Name, DisplayName, and EmailAddress columns with the LIKE operator.
Specify Name, DisplayName, and EmailAddress one at a time.
The JIRA supports filters based on these columns combined with the Active or IncludeInactive columns. For example the following queries are processed server side:
SELECT * FROM Users WHERE Name LIKE '%John%' AND Active=false AND IncludeInactive=true
Query the Users belonging to a specific group by specifying either the GroupName or the GroupId:
SELECT * FROM Users WHERE GroupName = 'Testing team' SELECT * FROM Users WHERE GroupId = '3dd7e7a1-77f7-4ac1-b8e1-a069830a7f1d'
You can also retrieve a list of all groups and their members:
SELECT * FROM Users WHERE GroupName IN (SELECT Name FROM Groups)
Columns
Name | Type | ReadOnly | References | SupportedOperators | Platform | Description |
GroupName | String | True | =,IN | Common |
The name of the group the user is part of. | |
GroupId | String | True | =,IN | Common |
The Id of the group the user is part of. | |
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. | ||
AccountId [KEY] | String | True | Cloud |
The accountId of the user, which uniquely identifies the user across all Atlassian products. | ||
AccountType | String | False | Cloud |
The accountType of the user. | ||
Key [KEY] | String | True | Server |
The key of the user. | ||
Name | String | False | Server |
The name of the user. |