IssueAffectedVersions
Returns the software versions affected by specific issues, indicating where the bug or feature is observed.
Table Specific Information
You can search IssueAffectedVersions by using SQL and JQL (Jira Query Language).
Select
The provider uses the Jira API to process some of the filters.
The provider processes other filters within the provider.
The available columns for IssueAffectedVersions are IssueId, IssueKey, and JQL. For example:
SELECT * FROM IssueAffectedVersions 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 version that is marked as affected by the issue. Used to track which versions are impacted. | |
| IssueId [KEY] | Integer |
Issues.Id | =,<>,>,>=,<,<=,IN,NOT IN | Common | The internal numeric ID of the issue associated with the affected version. |
| IssueKey | String |
Issues.Key | =,<>,>,>=,<,<=,IN,NOT IN | Common | The readable issue key (such as 'PROJ-123') that identifies the issue associated with the affected version. |
| IssueCreatedDate | Datetime | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The date and time when the issue related to the affected version was originally created. | |
| IssueUpdatedDate | Datetime | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The date and time when the issue associated with the affected version was last updated. | |
| Name | String | Common | The name assigned to the affected version, typically representing a release or milestone. | ||
| Archived | Boolean | Common | If the value is 'true', the affected version has been archived and is no longer active in project planning. | ||
| Released | Boolean | Common | If the value is 'true', the affected version has been officially released. | ||
| ReleaseDate | Date | Common | The scheduled or actual release date for the affected version, if available. |
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) allows structured querying of issues. Use this to filter affected versions based on issue criteria. |