IssueFixVersions
Query the available IssueFixVersions in Jira.
テーブル固有の情報
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 Id of the fix version. | |
| IssueId [KEY] | Integer |
Issues.Id | =,<>,>,>=,<,<=,IN,NOT IN | Common | The issue Id of the fix version. |
| IssueKey | String |
Issues.Key | =,<>,>,>=,<,<=,IN,NOT IN | Common | The issue key of the fix version. |
| IssueCreatedDate | Datetime | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The date the fix version's issue was created. | |
| IssueUpdatedDate | Datetime | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The date the fix version's issue was last updated. | |
| Name | String | Common | The name of the fix version. | ||
| Archived | Boolean | Common | A boolean indicating if the fix is archived. | ||
| Released | Boolean | Common | A boolean indicating if the fix is released. | ||
| ReleaseDate | Datetime | Common | The release date. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| JQL | String | JQL (Jira Query Language) allows you to build structured queries. |