Manages default role actors, who are automatically assigned to roles when new projects are created.

Table-Specific Information

SELECT

The connector uses the Jira API to process filters based on the RoleId column. The connector processes all other filters client-side.

For example, the following queries are processed server-side:

SELECT * FROM RoleActors WHERE RoleId = '10002';

INSERT

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

Jira Data Center

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

Jira Cloud

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

Jira Data Center

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 unique identifier assigned to the role actor, used to distinguish users or groups associated with a Jira project role.
DisplayName	String	False			Common	The display name of the user or group associated with the project role. This can differ based on the user's privacy settings.
Type	String	False			Common	The type of role actor, such as 'atlassian-user-role-actor' for users or 'atlassian-group-role-actor' for groups.
AvatarUrl	String	False			Common	The URL to the avatar image representing the user or group in the UI.
ActorUserAccountId	String	False	Users.AccountId		Cloud	The Atlassian account ID of the user associated with the project role. This ID uniquely identifies the user across all Atlassian products.
ActorGroupName	String	False	Groups.Name		Cloud	The name of the group associated with the project role. Since group names can change, group IDs are recommended for stable identification.
ActorGroupDisplayName	String	False			Cloud	The human-readable display name of the group that acts in the role.
ActorGroupGroupId	String	False	Groups.Id		Cloud	The stable ID of the group associated with the project role.
Name	String	False			Server	The name of the Jira role that this actor is assigned to, such as 'Developers' or 'Administrators'.
RoleId	Long	False	Roles.Id	=,IN	Common	The unique identifier for the Jira role that the actor is assigned to.

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
UserKey	String	Used only on Jira Server. The key of the user to be inserted or removed from the project role.
GroupName	String	Used only on Jira Server. The name of the group to be inserted or removed from the project role.