Tableau Connector for Jira

Build 22.0.8479

Worklogs

Create, modify, delete and query the available Worklogs in JIRA.

テーブル固有の情報

Select

このテーブルをクエリして、JIRA プロジェクトの作業ログを取得できます。connector は、Jira API を使用して次のカラムおよび演算子に基づいてフィルタを処理します。 connector は他のフィルタをクライアント側で実行します。 SupportEnhancedSQL をfalse に設定することで、クエリのクライアント側の実行をオフにできます。

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

SELECT * FROM Worklogs WHERE IssueId=10001

Insert

挿入には、IssueId、Started およびTimeSpentSeconds が必須です。次のクエリは、課題の作業完了を記録します。

INSERT INTO Worklogs(IssueId,Started,TimeSpentSeconds) VALUES (10003,'2017-03-20 20:00:00', 10000)

Update

作業ログを変更するには、worklog Id とIssueId の両方が必要です。

UPDATE Worklogs SET TimeSpentSeconds=200000 WHERE Id=10602 AND IssueId=10003

Delete

Id およびIssueId を入力して、課題の作業ログを削除します。

DELETE FROM Worklogs WHERE Id=10602 AND IssueId=10003

Columns

Name Type ReadOnly References SupportedOperators Platform Description
Id [KEY] String True = Common

The Id of the worklog.

IssueId [KEY] Integer False

Issues.Id

=,<>,>,>=,<,<=,IN,NOT IN Common

The issue Id of the worklog.

IssueKey String False

Issues.Key

=,IN,NOT IN Common

The key of the issue.

ProjectId Integer True

Projects.Id

=,IS,IS NOT,IN,NOT IN Common

The project Id of the worklog's issue.

ProjectName String True =,IS,IS NOT,IN,NOT IN Common

The project name of the worklog's issue.

IssueCreatedDate Datetime True =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common

The date the worklogs's issue was created.

IssueUpdatedDate Datetime True =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common

The date the worklogs's issue was last updated.

AuthorDisplayName String True

Users.DisplayName

=,!=,IS,IS NOT,IN,NOT IN Common

The display name of the author of the worklog.

UpdateAuthorDisplayName String True

Users.DisplayName

=,!=,IS,IS NOT,IN,NOT IN Common

The display name of the author who has updated the worklog.

Comment String False =,LIKE,NOT LIKE Common

The comment of the worklog.

Created Datetime True =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common

The date the worklog was created.

Updated Datetime True Common

The update date of the worklog.

VisibilityType String False Common

The visibility type of the worklog.

VisibilityValue String False Common

The visibility value of the worklog.

Started Datetime False Common

The start date of the worklog.

TimeSpent String False Common

The spent time of the worklog.

TimeSpentSeconds Long False Common

The time spent in seconds for the worklog.

AuthorAccountId String True

Users.AccountId

=,!=,IS,IS NOT,IN,NOT IN Cloud

The name of the author of the worklog.

UpdateAuthorAccountId String True

Users.AccountId

=,!=,IS,IS NOT,IN,NOT IN Cloud

The name of the author who has updated the worklog.

AuthorAccountKey String True

Users.Key

=,!=,IS,IS NOT,IN,NOT IN Server

The key of the author of the worklog.

AuthorAccountName String True

Users.Name

=,!=,IS,IS NOT,IN,NOT IN Server

The name of the author of the worklog.

UpdateAuthorAccountKey String True

Users.Key

=,!=,IS,IS NOT,IN,NOT IN Server

The key of the author who has updated the worklog.

UpdateAuthorAccountName String True

Users.Name

=,!=,IS,IS NOT,IN,NOT IN Server

The name of the author who has updated the worklog.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479