ProjectRoleActors
Query the actors who act in a role for specific projects in Jira.
Select
The 本製品 will use the Jira API to process filters that refer to ProjectId, ProjectKey and 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 ProjectId, ProjectKey and RoleId. Note that either ProjectId, ProjectKey or RoleId must be specified with a comparison type of equals (=) for SELECT SQL statement.
For example, the following queries are processed server side:
Retrieve all actors for a specific project:
SELECT * FROM ProjectRoleActors WHERE ProjectId = '10650'
SELECT * FROM ProjectRoleActors WHERE ProjectKey = 'MYP'
Retrieve all actors for a specific role in all projects:
SELECT * FROM ProjectRoleActors WHERE RoleId = '10329'
Retrieve all actors for a specific project:
SELECT * FROM ProjectRoleActors WHERE RoleId = '10329' AND ProjectId = '10650'
Retrieve all actors for specific projects:
SELECT * FROM ProjectRoleActors WHERE RoleId = '10329' AND ProjectId IN ('10650', '10651', '10652')
Retrieve all actors for specific roles in a project:
SELECT * FROM ProjectRoleActors WHERE RoleId IN ('10329', '10330', '10331') AND ProjectId = '10650'
Insert
Cloud
Add a user as an actor to a role in a specific project by specifying the user's account Id.
INSERT INTO ProjectRoleActors (ProjectId, RoleId, ActorUserAccountId) VALUES ('10650', '10329', '63acbf336f068efec8f6e0c3')
Add a group as an actor to a role in a specific project by either specifying the group's Id or name.
INSERT INTO ProjectRoleActors (ProjectId, RoleId, ActorGroupGroupId) VALUES ('10650', '10329', '0eed15e3-80cc-41d0-ba1a-b408658caf4d')
INSERT INTO ProjectRoleActors (ProjectId, RoleId, ActorGroupName) VALUES ('10650', '10329', 'JohnTest1')
Server
Add a user as an actor to a role by specifying the project, role and user's name.
INSERT INTO ProjectRoleActors (ProjectId, RoleId, UserName) VALUES ('10000', '10101', 'myuser')
Add a group as an actor to a role by specifying the project, role and group's name.
INSERT INTO ProjectRoleActors (ProjectId, RoleId, GroupName) VALUES ('10000', '10101', 'test-group')
Delete
Cloud
Delete an actor from a role by specifying the project, role and the user's account Id, the group's name or the group's Id.
DELETE FROM ProjectRoleActors WHERE ProjectId = '10650' AND RoleId = '10329' AND ActorUserAccountId = '63acbf336f068efec8f6e0c3'
DELETE FROM ProjectRoleActors WHERE ActorGroupGroupId = '0eed15e3-80cc-41d0-ba1a-b408658caf4d' AND ProjectId = '10650' AND RoleId = '10330'
DELETE FROM ProjectRoleActors WHERE ActorGroupName = 'JohnTest1' AND ProjectId = '10650' AND RoleId = '10330'
Server
Delete a default actor from a role by specifying the user's name or the group's name.
DELETE FROM ProjectRoleActors WHERE ProjectId = '10000' AND RoleId = '10101' AND UserName = 'myuser'
DELETE FROM ProjectRoleActors WHERE ProjectId = '10000' AND RoleId = '10101' 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. | ||
Name | String | False | Server |
The name of the role. | ||
AvatarUrl | String | False | Common |
The avatar of the role actor. | ||
ActorUserAccountId | String | False | 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 | 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 | Cloud |
Details of the group associated with the role. The ID of the group. | ||
RoleId | Long | False |
Roles.Id | =,IN | Common |
The Id of the role. |
ProjectId | Integer | False |
Projects.Id | =,IN | Common |
The Id of the project associated with the role. |
ProjectKey | String | False |
Projects.Key | =,IN | Common |
The key of the project associated with the role. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
Name | Type | Description |
UserName | String |
Server platform only. Input for Insert and Delete statements. Details of the user associated with the role. The name 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. |