Returns the software versions affected by specific issues, indicating where the bug or feature is observed.

View-Specific Information

You can query IssueAffectedVersions by using a Jira Query Language (JQL) query as a filter.

SELECT

The component uses the Jira API to process filters based on the IssueId, IssueKey, and JQL columns. The component processes all other filters client-side.

For example, the following queries are processed server-side:

SELECT * FROM IssueAffectedVersions WHERE IssueId > 10022 AND IssueId < 10090;

Columns

Name	Type	References	SupportedOperators	Platform	Description
VersionId [KEY]	String		=,>,>=,<,<=,IS,IS 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.

Pseudocolumns

Pseudocolumn fields are used in the WHERE clause of SELECT statements and offer more granular control over the data 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.