Specific field value has been lost in jira issues, how to recover that value?

Question

Hello Community Team,

Specific field value has been lost in jira issues due to wrong scriptrunner script.

In the issue create and edit screen, we have a list field called “Basket”; that is the mandatory field.

It was working as expected, due to script malfunction We got up with a problem where the basket value was not updated for issue and was getting bypassed as optional (null) on some updated Jira issues, and existing data on the basket in issue was lost.

for existing value of the field, there is no observation on history.

Now, how to recover the values of specific field for existing issues ?

Laurie Sciutti · Answer

Hi @Pramod Kumar Reddy ~ maybe try running a search for "Bucket" or even a value of that field in your Audit Log....that may give you a bit more direction of updates...

Radek Dostál · Answer

Long story short, if you have no issue history, it means you kind of "brute forced" the update.

History is the only way how you could recover them. Once the values are deleted they are deleted from customfieldvalue table and that table is the only one that holds reference to the value.

The change history is then the only thing that could contain the reference to that previous value, but if you don't have it, there is nothing to restore it from.

The only solution for you would be to take it from an older backup.