Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

How can i get original value of a custom field from bd ?

Deleted user January 15, 2019

I need to retrieve all the previous values of a custom field from certain ticket/issue using sql from jira's database. Using the tables "changeitem" and "changegroup" I am able to obtain all the values of the custom field from a certain ticket whenever it changes, but i cant get the initial value of the customfield. The "jiraissues" table doesnt have the initial value either

1 answer

0 votes
Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 16, 2019

The changeitem table contains "old value" and "new value".  To get the original value on create, read the earliest change of the field.

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events