JDBC Driver for Jira

Build 22.0.8462

IssueChangelogs

Query the available IssueChangelogs in JIRA.

Table Specific Information

You can search IssueChangelogs by using SQL and JQL (JIRA Query Language).

Select

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

The driver processes other filters within the driver. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

The available columns for IssueChangelogs are IssueId, IssueKey, and JQL. For example:

SELECT * FROM IssueChangelogs WHERE IssueId<>10022

Columns

Name Type References SupportedOperators Platform Description
HistoryId Integer Common The Id of the change.
IssueId Integer

Issues.Id

=,<>,>,>=,<,<=,IN,NOT IN Common The Id of the issue.
IssueKey String

Issues.Key

=,<>,>,>=,<,<=,IN,NOT IN Common The key of the issue.
Created Datetime Common The creation date of the change.
IssueCreatedDate Datetime =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common The date the change's issue was created.
IssueUpdatedDate Datetime =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN Common The date the change's issue was last updated.
ItemField String Common The item field of the change.
ItemFieldType String Common The item field type of the change.
ItemFrom String Common The item the issue changed from.
ItemFromString String Common The description of the item the issue changed from.
ItemTo String Common The item the issue changed to.
ItemToString String Common The description of the item the issue changed to.
AuthorDisplayName String Common The display name of the author who has updated the change.
AuthorAccountId String Cloud The author name of the change.
AuthorName String Cloud The author name of the change.
AuthorAccountKey String Server The key of the author of the change.
AuthorAccountName String Server The name of the author who has updated the change.

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
JQL String JQL (JIRA Query Language) allows you to build structured queries.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462