ApplicationRoles
Retrieves all configured application roles, which control user access and are managed through Jira's Application Access settings.
Table Specific Information
Select
The add-in uses the Jira API to process some of the filters.
The add-in processes other filters within the add-in.
For example, the following queries are processed server side:
SELECT * FROM ApplicationRoles WHERE Key = 'jira-software'
Columns
| Name | Type | References | SupportedOperators | Platform | Description |
| Key [KEY] | String | = | Common | A unique identifier used to reference the application role programmatically. This value is used in API calls and internal configuration. | |
| Name | String | Common | The user-friendly display name of the application role, such as 'Jira Software' or 'Jira Service Management'. | ||
| Groups | String | Common | A comma-separated list of Jira groups associated with this application role. Users in these groups gain access to the role's features. | ||
| DefaultGroups | String | Common | A comma-separated list of groups automatically assigned this role when new users are created, providing them with default application access. | ||
| SelectedByDefault | Boolean | Common | If the value is 'true', this application role is automatically selected for new users during account creation unless otherwise specified. | ||
| NumberOfSeats | Integer | Common | The total number of user licenses allocated to this application role, as defined by your Jira subscription. | ||
| RemainingSeats | Integer | Common | The number of user licenses still available for this application role, based on current usage and subscription limits. | ||
| UserCount | Integer | Common | The total number of active users currently consuming seats under this application role. | ||
| UserCountDescription | String | Common | A brief description of the user types included in the seat count, such as active users or users with specific group memberships. | ||
| HasUnlimitedSeats | Boolean | Common | If the value is 'true', there is no limit to the number of users who can be assigned this application role. | ||
| Platform | Boolean | Common | If the value is 'true', this application role is part of the Jira platform core (jira-core), as opposed to an add-on like Jira Software or Jira Service Management. |