It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Custom Fields and Missing Data

We have a custom field "start date" and another called "PTO Start Date" this morning something happened and almost all the values are empty. Is the dat gone from the database? Help!!!

1 answer

Hi Daniel,

You can run the query from the Atlassian Database Schema page to see if the data is still there:

select * from customfieldvalue where customfield=(select ID from customfield where cfname='YourFieldName');

From my testing, if I delete a value the data is immediately gone from the database so if you do find it there the first step is going to be to perform a full re-index so you'll need to schedule a maintenance period.

If you do not find the values in the database you'll need to restore from the last backup.  I would also recommend opening a support ticket so the Support team can take a look at the logs and help identify what may have happened to cause this behavior and how to prevent it again in the future.

Cheers,

Branden

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted in Jira Core

How to manage many similar workflows?

I have multiple projects that use variations of the same base workflow. The variations depend on the requirements of the project or issue type. The variations mostly come in the form of new statuses ...

1,751 views 8 2
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you