Roles
Query the available roles in JIRA.
Select
The adapter will use the JIRA API to process filters that refer to Id while the rest of the filter is executed client side within the adapter. 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. |