ProjectRoles
Query roles for all projects in Jira.
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 | The Id of the role. | |
| RoleName | String |
Roles.Name | Common | The name of the role. | |
| ProjectId [KEY] | Integer |
Projects.Id | =,IN | Common | The Id of the project associated with the role. |
| ProjectKey [KEY] | String |
Projects.Key | =,IN | Common | The key of the project associated with the role. |