Audit

Query the audit log of your Jira account.

テーブル固有の情報

本製品はJira API を使用して一部のフィルタを処理します。

本製品は他のフィルタを本製品内で処理します。

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

SELECT * FROM Audit WHERE Filter = 'ab'


Name	Type	References	SupportedOperators	Platform	Description
RecordId	Integer			Common	The Id of the audit record.
Summary	String			Common	Summary of the change.
RemoteAddress	String			Common	The remote address of the record.
AuthorKey	String			Common	Key of the author that made the change.
Created	Datetime			Common	Date on when the change was made.
Category	String			Common	Category of the change.
EventSource	String			Common	What triggered the event.
Description	String			Common	Description of the change.
ItemId	String			Common	Unique identifier of the object item.
ItemName	String			Common	Name of the object item.
ItemTypeName	String			Common	Typename of the object item.
ItemParentId	String			Common	Identifier of the parent of the object item.
ItemParentName	String			Common	Parent name of the object item.
FieldName	String			Common	The name of the changed field.
ChangedFrom	String			Common	The updated value.
ChangedTo	String			Common	The previous value.

SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。


Name	Type	Description
Filter	String		Containing a string in at least one field. For example, providing up will return all audit records where one or more fields contains words such as update.