ODBC Driver for Jira

Build 24.0.8963

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.

The available columns for server-side filtering for IssueChangelogs are IssueId, IssueKey, ProjectId, ProjectKey, ProjectName, and JQL. For example:

SELECT * FROM IssueChangelogs WHERE IssueId<>10022
SELECT * FROM IssueChangelogs WHERE ProjectKey = 'PRJ'

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.
ProjectId Integer

Projects.Id

=,!=,IS,IS NOT,IN,NOT IN Common The project Id of the issue.
ProjectKey String

Projects.Key

=,!=,IS,IS NOT,IN,NOT IN Common The project key of the issue.
ProjectName String =,!=,IS,IS NOT,IN,NOT IN Common The project name of the issue.

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) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.8963