IssueFixVersions
Returns the list of versions in which specific issues are expected to be resolved.
Table Specific Information
You can search IssueFixVersions by using SQL and JQL (Jira Query Language).
Select
The cmdlet uses the Jira API to process some of the filters.
The cmdlet processes other filters within the cmdlet.
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 unique identifier of the fix version assigned to the issue, used to track when and where a bug or feature was resolved. | |
| IssueId [KEY] | Integer |
Issues.Id | =,<>,>,>=,<,<=,IN,NOT IN | Common | The internal numeric ID of the issue that has been associated with this fix version. |
| IssueKey | String |
Issues.Key | =,<>,>,>=,<,<=,IN,NOT IN | Common | The human-readable key of the issue, such as 'PROJ-123', which links it to the fix version. |
| IssueCreatedDate | Datetime | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The timestamp indicating when the issue related to this fix version was originally created in Jira. | |
| IssueUpdatedDate | Datetime | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The timestamp indicating the most recent update made to the issue associated with this fix version. | |
| Name | String | Common | The display name of the fix version, often reflecting a product release or milestone, such as 'v1.0' or 'Q2 Patch'. | ||
| Archived | Boolean | Common | If the value is 'true', the fix version has been archived, meaning it is hidden from standard version pickers and no longer actively used in projects. | ||
| Released | Boolean | Common | If the value is 'true', the fix version has been officially released, typically signifying that associated issues have been completed or deployed. | ||
| ReleaseDate | Datetime | Common | The scheduled or actual release date of the fix version, used for tracking project milestones and timelines. |
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 | Jira Query Language (JQL) enables advanced filtering by allowing users to write structured queries to search for issues based on fix versions and other attributes. |