IssueAffectedVersions
Returns the software versions affected by specific issues, indicating where the bug or feature is observed.
テーブル固有の情報
SQL とJQL (Jira Query Language) を使用して、IssueAffectedVersions を検索できます。
Select
本製品 はJira API を使用して一部のフィルタを処理します。
本製品 は他のフィルタを本製品 内で処理します。
IssueAffectedVersions で使用可能なカラムは、IssueId、IssueKey、およびJQL です次に例を示します。
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| JQL | String | Jira Query Language (JQL) allows structured querying of issues. Use this to filter affected versions based on issue criteria. |