ProjectRoles
Retrieves role definitions that can be assigned across projects, such as 'Developers' or 'Administrators'.
Select
The connector will use the Jira API to process filters that refer to ProjectId and ProjectKey while the rest of the filter is executed client side within the connector. The Jira APIs support filters using the equals (=) or IN operator with ProjectId and ProjectKey.
For example, the following queries are processed server side:
Retrieve all roles for each project:
SELECT * FROM ProjectRoles
Retrieve all roles for a specific project:
SELECT * FROM ProjectRoles WHERE ProjectId = '10000'
Columns
| Name | Type | References | SupportedOperators | Platform | Description |
| RoleId [KEY] | Long |
Roles.Id | Common | A unique identifier for the project role. Project roles define a set of permissions and responsibilities within a specific Jira project. | |
| RoleName | String |
Roles.Name | Common | The display name of the project role, such as 'Developers', 'Administrators', or 'Users'. | |
| ProjectId [KEY] | Integer |
Projects.Id | =,IN | Common | The numeric ID of the project that this role is associated with. |
| ProjectKey [KEY] | String |
Projects.Key | =,IN | Common | The unique key of the project where this role is defined, used to reference the project in Jira queries and configurations. |