Issue Type Definitions

ISSUETYPEDEFINITIONS

Column

ID

NAME

DESCRIPTION

URL

SEQUENCE

Type

VARCHAR

VARCHAR

VARCHAR

VARCHAR

BIGINT

Indexed

x






All the Issue types definitions become visible to any logged in Jira user

Example 1
SELECT
  *
FROM
  ISSUETYPEDEFINITIONS 

ID  

NAME  

DESCRIPTION  

URL  

SEQUENCE  

ISSUBTASK  

10100

Epic

Created by Jira Software - do not edit or delete. Issue type for a big user story that needs to be broken down.

/images/icons/issuetypes/epic.svg

null

FALSE

10101

Story

Created by Jira Software - do not edit or delete. Issue type for a user story.

/images/icons/issuetypes/story.svg

null

FALSE

10000

Task

A task that needs to be done.

/secure/viewavatar?size=xsmall&avatarId=10318&avatarType=issuetype

null

FALSE

10102

Bug

A problem which impairs or prevents the functions of the product.

/secure/viewavatar?size=xsmall&avatarId=10303&avatarType=issuetype

null

FALSE

10001

Sub-task

The sub-task of the issue

/secure/viewavatar?size=xsmall&avatarId=10316&avatarType=issuetype

null

TRUE