IssueFixVersions
Query the available IssueFixVersions in JIRA.
Table Specific Information
You can search IssueFixVersions 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 IssueFixVersions are IssueId, IssueKey, and JQL. For example:
SELECT * FROM IssueFixVersions WHERE IssueId > 10022 AND IssueId < 10090
Columns
| Name | Type | References | SupportedOperators | Platform | Description |
| VersionId [KEY] | String | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The Id of the fix version. | |
| IssueId [KEY] | Integer |
Issues.Id | =,<>,>,>=,<,<=,IN,NOT IN | Common | The issue Id of the fix version. |
| IssueKey | String |
Issues.Key | =,<>,>,>=,<,<=,IN,NOT IN | Common | The issue key of the fix version. |
| IssueCreatedDate | Datetime | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The date the fix version's issue was created. | |
| IssueUpdatedDate | Datetime | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The date the fix version's issue was last updated. | |
| Name | String | Common | The name of the fix version. | ||
| Archived | Boolean | Common | A boolean indicating if the fix is archived. | ||
| Released | Boolean | Common | A boolean indicating if the fix is released. | ||
| ReleaseDate | Datetime | Common | The release date. |
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. |