Roles
Lists all roles configured in Jira, such as 'Service Desk Team' or 'Project Manager'.
Table-Specific Information
SELECT
The component uses the Jira API to process filters based on the Id column. The component processes all other filters client-side.For example, the following queries are processed server-side:
SELECT * FROM Roles WHERE Id = '10002';
INSERT
Insert a role by specifying the Name column.INSERT INTO Roles(Name, Description) VALUES ('Custom Role 1', 'My custom role 1.')
UPDATE
Update a role by specifying the Id column and the columns to update.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 |
Indicates whether this role is designated as the administrator role for the associated project. | ||
| IsDefault | Boolean | False | Cloud |
Indicates whether this role is automatically assigned to users by default for new projects. |