Table CUSTOMFIELDS
This view does not expose all custom fields, but only those which are available for user due to his JIRA permissions.
Column | Type | Notes |
---|---|---|
ID | BIGINT NOT NULL | |
ISSUE | BIGINT NOT NULL | Points to Table ISSUES |
TYPEID | BIGINT NOT NULL | See https://confluence.atlassian.com/jirakb/how-to-find-id-for-custom-field-s-744522503.html |
STRINGVALUE | VARHAR | |
NUMBERVALUE | NUMERIC | |
TEXTVALUE | VARCHAR | |
DATEVALUE | DATETIME | |
NAME | VARCHAR | |
DESCRIPTION | VARCHAR |