RoleActors
Query the default actors for project roles in Jira.
Select
The 本製品 will use the Jira API to process filters that refer to RoleId while the rest of the filter is executed client side within the 本製品. The Jira APIs support filters using the equals (=) and IN operator with RoleId.
For example, the following queries are processed server side:
Retrieve all the default actors for all roles:
SELECT * FROM RoleActors
Retrieve all the default actors for a specific role:
SELECT * FROM RoleActors WHERE RoleId = '10002'
Insert
Cloud
Add a user as a default actor to a role by specifying the user's account Id.
INSERT INTO RoleActors (ActorUserAccountId, RoleId) VALUES ('63acbf336f068efec8f6e0c3', '10326')
Add a group as a default actor to a role by either specifying the group's Id or name.
INSERT INTO RoleActors (ActorGroupGroupId, RoleId) VALUES ('ad8da7e1-7b66-408e-a61c-c4c8383ca5d1', '10326')
INSERT INTO RoleActors (ActorGroupName, RoleId) VALUES ('testGroupName', '10326')
Server
Add a user as a default actor to a role by specifying the user's key.
INSERT INTO RoleActors (RoleId, UserKey) VALUES ('10102', 'JIRAUSER10001')
Add a group as a default actor to a role by specifying the group's name.
INSERT INTO RoleActors (RoleId, GroupName) VALUES ('10102', 'test-group')
Delete
Cloud
Delete a default actor from a role by specifying the RoleId and the user's account Id, the group's name or the group's Id.
DELETE FROM RoleActors WHERE RoleId = '10326' AND ActorUserAccountId = '63acbf336f068efec8f6e0c3'
DELETE FROM RoleActors WHERE RoleId = '10325' AND ActorGroupName = 'Developers'
DELETE FROM RoleActors WHERE RoleId = '10325' AND ActorGroupGroupId = '6dd7f7e1-77f0-4cd1-b8e1-a069830a8f1d'
Server
Delete a default actor from a role by specifying the user's key or the group's name.
DELETE FROM RoleActors WHERE RoleId = '10102' AND UserKey = 'JIRAUSER10001'
DELETE FROM RoleActors WHERE RoleId = '10102' AND GroupName = 'test-group'
Columns
Name | Type | ReadOnly | References | SupportedOperators | Platform | Description |
Id [KEY] | Long | False | Common |
The ID of the role actor. | ||
DisplayName | String | False | Common |
The display name of the role actor. For users, depending on the user?s privacy setting, this may return an alternative value for the user's name. | ||
Type | String | False | Common |
The type of role actor. | ||
AvatarUrl | String | False | Common |
The avatar of the role actor. | ||
ActorUserAccountId | String | False |
Users.AccountId | Cloud |
Details of the user associated with the role. The account ID of the user, which uniquely identifies the user across all Atlassian products. | |
ActorGroupName | String | False |
Groups.Name | Cloud |
Details of the group associated with the role. The name of the group. As a group's name can change, use of groupId is recommended to identify the group. | |
ActorGroupDisplayName | String | False | Cloud |
Details of the group associated with the role. The display name of the group. | ||
ActorGroupGroupId | String | False |
Groups.Id | Cloud |
Details of the group associated with the role. The ID of the group. | |
Name | String | False | Server |
The name of the role. | ||
RoleId | Long | False |
Roles.Id | =,IN | Common |
The Id of the role. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
UserKey | String |
Server platform only. Input for Insert and Delete statements. Details of the user associated with the role. The key of the user. |
GroupName | String |
Server platform only. Input for Insert and Delete statements. Details of the group associated with the role. The name of the group. |