Audit
Query the audit log of your Jira account.
Table Specific Information
Select
The add-in uses the Jira API to process some of the filters.
The add-in processes other filters within the add-in.
For example, the following queries are processed server side:
SELECT * FROM Audit WHERE Filter = 'ab'
Columns
| 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. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| 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. |