Users
Provides access to Jira users. Supports querying user details including account ID, email, and group memberships.
Select
The add-in executes filters other than the following client-side within the add-in. 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)
Use the IssueKey and ProjectKey pseudo-columns to find users who can browse a specific issue or any issue in a project.
SELECT * FROM Users WHERE IssueKey = 'PRJ-1' SELECT * FROM Users WHERE ProjectKey = 'PRJ'
Insert
The input to INSERT must be an email address:INSERT INTO Users(EmailAddress) VALUES ('[email protected]')
Columns
| Name | Type | ReadOnly | References | SupportedOperators | Platform | Description |
| GroupName | String | True | =,IN | Common |
The name of the Jira group that the user belongs to. Groups are used to manage permissions and roles collectively. | |
| EmailAddress | String | False | = | Common |
The primary email address associated with the user's Jira account. This is often used for notifications and communication. | |
| Active | Bool | True | Common |
If the value is 'true', the user account is currently active and able to log in. If the value is 'false', the account is deactivated and cannot access Jira. | ||
| TimeZone | String | True | Common |
The time zone preference set in the user's profile. This affects how times and dates are displayed in the interface for that user. | ||
| Locale | String | True | Common |
The locale setting for the user, which defines the language and regional formatting used in the UI, such as number or date formats. | ||
| AccountId [KEY] | String | True | Cloud |
The globally unique identifier for the user across all Atlassian cloud products. This replaces legacy fields like 'key' and 'name' in cloud environments. | ||
| AccountType | String | False | Cloud |
Indicates the type of user account, such as 'atlassian' for managed users or 'app' for automated or bot accounts. | ||
| Products | String | False |
A comma-separated list of Jira products the user has access to, such as 'jira-core', 'jira-servicedesk', 'jira-product-discovery', or 'jira-software'. This helps determine license usage and available features. | |||
| Key [KEY] | String | True | Server |
The legacy Jira user key. While deprecated in cloud environments, it is still used in server and data center editions for user identification. | ||
| Name | String | False | Server |
The legacy Jira username. This is primarily used in server environments and has been replaced by 'AccountId' in cloud. |