Retrieves mappings between users and their associated groups.

View-Specific Information

SELECT

The add-in uses the Jira API to process filters based on the GroupName and GroupId columns. The add-in processes all other filters client-side.

You must specify a GroupName or GroupId to retrieve results. If neither is specified, the add-in automatically iterates through all groups to retrieve all associated users, which may result in increased query times.

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

SELECT * FROM GroupsUsers WHERE GroupId = '37f2babd-27ef-442e-8642-15b6cafba31c';
SELECT * FROM GroupsUsers WHERE GroupName = 'jira-software-users';

Columns

Name	Type	References	SupportedOperators	Platform	Description
AccountId [KEY]	String	Users.AccountId		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.