SSIS Components for Jira

Build 25.0.9434

Roles

Lists all roles configured in Jira, such as 'Service Desk Team' or 'Project Manager'.

Select

本製品 はJira API を使用してId を参照するフィルタを処理します。その他のフィルタはクライアント側で本製品 内部で処理されます。Jira API は、Id でイコール(=)演算子を使用するフィルタをサポートしています。

例えば、次のクエリはサーバー側で処理されます。

すべての利用可能なロールを取得する:

SELECT * FROM Roles

特定のロールを取得する:

SELECT * FROM Roles WHERE Id = '10002'

Update

ロールId を指定して、ロールの名前と説明を更新します。

UPDATE Roles SET Description = 'test_updated', Name = 'test_updated' WHERE Id = 10002

Delete

Id を指定して、ロールを削除します。

DELETE FROM Roles WHERE Id = '10002'

Columns

Name Type ReadOnly References SupportedOperators Platform Description
Id [KEY] Long False = Common

The unique identifier of the role within the Jira instance.

Name String False Common

The name of the project role, such as 'Developers', 'Administrators', or 'Users'.

Description String False Common

A textual explanation of the purpose or responsibilities associated with the role.

Actors String False Common

A list of users and groups assigned to this role, either by default or per project.

Scope String False Cloud

Defines the scope at which the role is applicable, such as global or project-specific.

IsAdmin Boolean False Cloud

If the value is 'true', this role is designated as the administrator role for the associated project. If the value is 'false', it is not an admin role.

IsDefault Boolean False Cloud

If the value is 'true', this role is automatically assigned to users by default for new projects. If the value is 'false', it is not a default role.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434