IssueChangelogs
Query the available IssueChangelogs in Jira.
Table Specific Information
You can search IssueChangelogs by using SQL and JQL (Jira Query Language).
Select
The add-in uses the Jira API to process some of the filters.
The add-in processes other filters within the add-in.
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. |