Manages role assignments within projects. Retrieves and updates users and groups assigned to project roles.

Table-Specific Information

SELECT

The add-in uses the Jira API to process filters based on the ProjectId, ProjectKey, and RoleId columns. The add-in processes all other filters client-side. You must specify a ProjectId, ProjectKey, or RoleId to retrieve results.

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';
SELECT * FROM ProjectRoleActors WHERE RoleId = '10329';
SELECT * FROM ProjectRoleActors WHERE RoleId = '10329' AND ProjectId = '10650';
SELECT * FROM ProjectRoleActors WHERE RoleId = '10329' AND ProjectId IN ('10650', '10651', '10652');
SELECT * FROM ProjectRoleActors WHERE RoleId IN ('10329', '10330', '10331') AND ProjectId = '10650';

INSERT

Jira 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 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');

Jira Data Center

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

Jira Cloud

Delete an actor from a role by specifying the project, role, and the user's account Id, group name, or group 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';

Jira Data Center

Delete an actor from a role by specifying the project, role, and the user's Name or group 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	True			Common	A unique identifier for the role actor, which represents either a user or a group assigned to a project role.
DisplayName	String	True			Common	The display name of the role actor. For users, this can reflect privacy settings and return a masked or alternative value instead of the actual name.
Type	String	True			Common	The type of role actor, such as 'atlassian-user-role-actor' for users or 'atlassian-group-role-actor' for groups.
Name	String	True			Server	The name of the project role that this actor is associated with.
AvatarUrl	String	True			Common	The URL to the avatar image representing the role actor (user or group).
ActorUserAccountId	String	False	Users.AccountId		Cloud	The unique account ID of the user acting in the role, consistent across all Atlassian products.
ActorGroupName	String	False			Cloud	The name of the group acting in the role. As group names can change, groupId is recommended for reliable identification.
ActorGroupDisplayName	String	True			Cloud	The human-readable display name of the group acting in the role.
ActorGroupGroupId	String	False			Cloud	The ID of the group associated with the project role.
RoleId	Long	False	Roles.Id	=,IN	Common	The ID of the project role that the actor is assigned to.
ProjectId	Integer	False	Projects.Id	=,IN	Common	The numeric ID of the project in which the role actor is defined.
ProjectKey	String	False	Projects.Key	=,IN	Common	The unique key of the project associated with the project role.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data returned from the data source.

Name	Type	Description
UserName	String	Used in Server platform only for Insert/Delete operations. Specifies the username of the user to be added or removed from the project role.
GroupName	String	Used in Server platform only for Insert/Delete operations. Specifies the name of the group to be added or removed from the project role.