Worklogs
Create, modify, delete and query the available Worklogs in Jira.
テーブル固有の情報
Select
このテーブルをクエリして、Jira プロジェクトの作業ログを取得できます。本製品 は、Jira API を使用して次のカラムおよび演算子に基づいてフィルタを処理します。 本製品 は他のフィルタをクライアント側で実行します。
例えば、次のクエリはサーバーサイドで処理されます。
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
GetDeleted
削除された作業ログのId を取得します。
GETDELETED FROM Worklogs
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. |