IssueFixVersions
Returns the list of versions in which specific issues are expected to be resolved.
テーブル固有の情報
SQL とJQL (Jira Query Language) を使用して、IssueFixVersions を検索できます。
Select
connector はJira API を使用して一部のフィルタを処理します。
connector は他のフィルタをconnector 内で処理します。
IssueFixVersions で使用可能なカラムは、IssueId、IssueKey、およびJQL です。次に例を示します。
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
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| 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. |