Query the default actors for project roles in Jira.

Select

The add-in will use the Jira API to process filters that refer to RoleId while the rest of the filter is executed client side within the add-in. 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

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

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.