IssueTypes

Query the available Issue Types in Jira.

Select

本製品はJira API を使用して一部のフィルタを処理します。

本製品は他のフィルタを本製品内で処理します。

SELECT * FROM IssueTypes WHERE Id = 3

挿入するにはName が必要です。次のクエリは、新しい課題タイプを作成します。

INSERT INTO IssueTypes (Name, Description, Subtask) VALUES ('Issue type name 3', 'test description', false)

課題タイプId を指定して更新できます。

UPDATE IssueTypes SET Name = 'Updated Name 3', Description = 'Updated description' WHERE Id = 10306

課題タイプId を指定して課題タイプを削除します。

DELETE FROM IssueTypes WHERE Id = 10306


Name	Type	ReadOnly	References	SupportedOperators	Platform	Description
Id [KEY]	String	True		=	Common	The Id of the issue type.
Name	String	False			Common	The name of the issue type.
Description	String	False			Common	The description of the issue type.
Subtask	Boolean	False			Common	The subtask of the issue type. Not applicable for update.
HierarchyLevel	Int	False			Cloud	Hierarchy level of the issue type.
IconUrl	String	True			Common	The icon URL of the issue type.
EntityId	String	True			Cloud	Unique ID for next-gen projects.
Self	String	True			Common	The URL of these issue type details.
Scope	String	True			Cloud	Details of the next-gen projects the issue type is available in.
AvatarId	Int	True			Common	The ID of the issue type's avatar.