GroupsUsers
Query the users available in Jira and their associated groups.
View Specific Information
Select
The provider utilizes the Jira API to process WHERE clause conditions that include the following columns and supported operators. Any remaining filters are applied client-side by the provider.
To effectively query the GroupsUsers view, you must specify a value for either the GroupName column or the GroupId column (the latter is exclusive to cloud instances). If neither GroupName nor GroupId is provided, the provider will automatically iterate through all groups to retrieve all associated users, which may result in increased query times.
As shown in the examples below, to retrieve users who belong to a specific group, include either the GroupName or GroupId in your query.
- Using GroupId:
SELECT * FROM GroupsUsers WHERE GroupId = '37f2babd-27ef-442e-8642-15b6cafba31c'
- Using GroupName:
SELECT * FROM GroupsUsers WHERE GroupName = 'jira-software-users'
Columns
| Name | Type | References | SupportedOperators | Platform | Description |
| AccountId [KEY] | String | Cloud | The accountId of the user, which uniquely identifies the user across all Atlassian products. | ||
| Key [KEY] | String | Server | The key of the user. | ||
| GroupId [KEY] | String | = | Cloud | The group Id the user is part of. | |
| GroupName [KEY] | String | = | Common | The group name the user is part of. | |
| 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 | Common | Indicates whether the user is active. | ||
| TimeZone | String | Common | The time zone specified in the user's profile. | ||
| Locale | String | Cloud | The locale of the user. | ||
| AccountType | String | Cloud | The accountType of the user. | ||
| Products | String | Cloud | A delimited string of jira products to which the user has access to, ex: jira-core,jira-servicedesk,jira-product-discovery,jira-software |