IssueSubtasks
Query the available IssueSubtasks in Jira.
テーブル固有の情報
SQL とJQL (Jira Query Language) を使用して、IssueSubtasks を検索できます。
Select
本製品 はJira API を使用して一部のフィルタを処理します。
本製品 は他のフィルタを本製品 内で処理します。
IssueSubtasks で使用可能なカラムは、IssueId、IssueKey、およびJQL です。次に例を示します。
SELECT * FROM IssueSubtasks WHERE IssueId = 10009 AND JQL = 'creator = john'
Columns
| Name | Type | References | SupportedOperators | Platform | Description |
| SubtaskId [KEY] | String | Common | The Id of the subtask. | ||
| SubtaskKey | String | Common | The key of the subtask. | ||
| IssueId | Integer |
Issues.Id | =,<>,>,>=,<,<=,IN,NOT IN | Common | The Id of the parent issue. |
| IssueKey | String |
Issues.Key | =,<>,>,>=,<,<=,IN,NOT IN | Common | The key of the parent issue. |
| IssueCreatedDate | Datetime | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The date the subtask's issue was created. | |
| IssueUpdatedDate | Datetime | =,<>,>,>=,<,<=,IS,IS NOT,IN,NOT IN | Common | The date the subtask's issue was last updated. | |
| Summary | String | Common | The summary of the subtask. | ||
| TypeId | String |
IssueTypes.Id | Common | The issue type Id of the subtask. | |
| TypeName | String |
IssueTypes.Name | Common | The issue type name of the subtask. | |
| TypeDescription | String |
IssueTypes.Description | Common | The issue type description of the subtask. | |
| TypeSubtask | Boolean |
IssueTypes.Subtask | Common | A boolean indicating if the issue is a subtask. | |
| PriorityId | String | Common | The priority Id of the subtask. | ||
| PriorityName | String | Common | The priority name of the subtask. | ||
| StatusId | String | Common | The status Id of the subtask. |
Pseudo-Columns
SELECT ステートメントのWHERE 句では、疑似カラムフィールドを使用して、データソースから返されるタプルを詳細に制御することができます。
| Name | Type | Description | |
| JQL | String | JQL (Jira Query Language) allows you to build structured queries. |