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.

ODBC Driver for Jira