JDBC Driver for Jira

Build 23.0.8839


Query the audit log of your Jira account.

Table Specific Information


The driver uses the Jira API to process some of the filters.

The driver processes other filters within the driver.

For example, the following queries are processed server side:

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.


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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839