Roles
Query the available roles in Jira.
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 Id of the role. | |
| Name | String | False | Common |
The name of the role. | ||
| Description | String | False | Common |
The description of the role. | ||
| Actors | String | False | Common |
The list of users who act in this role. | ||
| Scope | String | False | Cloud |
The scope of the role. | ||
| IsAdmin | Boolean | False | Cloud |
Whether this role is the admin role for the project. | ||
| IsDefault | Boolean | False | Cloud |
Whether this role is the default role for the project. |