Roles
Lists all roles configured in Jira, such as 'Service Desk Team' or 'Project Manager'.
Select
The add-in will use the Jira API to process filters that refer to Id while the rest of the filter is executed client side within the add-in. The Jira APIs support filters using the equals (=) operator with Id.
For example, the following queries are processed server side:
Retrieve all the available Roles:
SELECT * FROM Roles
Retrieve a specific Role:
SELECT * FROM Roles WHERE Id = '10002'
Update
Update the role name and description by specifying the role Id
UPDATE Roles SET Description = 'test_updated', Name = 'test_updated' WHERE Id = 10002
Delete
Delete a role by specifying the Id.
DELETE FROM Roles WHERE Id = '10002'
Columns
| Name | Type | ReadOnly | References | SupportedOperators | Platform | Description |
| Id [KEY] | Long | False | = | Common |
The unique identifier of the role within the Jira instance. | |
| Name | String | False | Common |
The name of the project role, such as 'Developers', 'Administrators', or 'Users'. | ||
| Description | String | False | Common |
A textual explanation of the purpose or responsibilities associated with the role. | ||
| Actors | String | False | Common |
A list of users and groups assigned to this role, either by default or per project. | ||
| Scope | String | False | Cloud |
Defines the scope at which the role is applicable, such as global or project-specific. | ||
| IsAdmin | Boolean | False | Cloud |
If the value is 'true', this role is designated as the administrator role for the associated project. If the value is 'false', it is not an admin role. | ||
| IsDefault | Boolean | False | Cloud |
If the value is 'true', this role is automatically assigned to users by default for new projects. If the value is 'false', it is not a default role. |