GroupsUsers
Retrieves mappings between users and their associated groups.
View Specific Information
Select
The add-in 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 add-in.
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 add-in 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 unique account ID of the user across all Atlassian products, used for identifying the user in a platform-wide context. | ||
| Key [KEY] | String | Server | The internal key used to identify the user within Jira. This can differ from the account ID. | ||
| GroupId [KEY] | String | = | Cloud | The unique identifier of the group that the user belongs to. Used to map group memberships. | |
| GroupName [KEY] | String | = | Common | The name of the group the user is associated with. Groups are often used for permission management. | |
| Name | String | Server | The Jira username of the user. This value can be deprecated in some contexts in favor of AccountId. | ||
| DisplayName | String | Common | The full display name of the user as shown in the Jira UI and user directories. | ||
| EmailAddress | String | Common | The email address associated with the user's Atlassian account. | ||
| Active | Bool | Common | If the value is 'true', the user is currently active and able to log in. If 'false', the account is inactive or suspended. | ||
| TimeZone | String | Common | The time zone configured in the user's profile, which affects how time-related data is displayed. | ||
| Locale | String | Cloud | The locale (language and region format) specified in the user's profile, used to localize the UI. | ||
| AccountType | String | Cloud | The type of account the user holds, such as 'atlassian' or 'app'. Useful for distinguishing user roles or access methods. | ||
| Products | String | Cloud | A comma-separated list of Jira products the user has access to. For example: jira-core, jira-servicedesk, jira-product-discovery, jira-software. |