ODBC Driver for Jira

Build 24.0.8963

RoleActors

Query the default actors for project roles in Jira.

Select

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

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963