• Community
  • Products
  • Jira
  • Questions
  • deleted a custom field and some how because this had the same name as another custom field this deleted options in another custom field

deleted a custom field and some how because this had the same name as another custom field this deleted options in another custom field

I cannot restore as I will lose a full days work what can I do can you call me please immediately on 0860630718

I had one custom field that was called "FSiAvailability Section" and was a multiselect custom field

but I then decided they would look better in a cascading select custom field so I created another custom field called Test FSiAvailability Section to hold the same values that were in the multiselect.
Some how after I spent 2 days setting all the values of the multiselect to none, and at the same time setting the value of the cascading select to the same Value that the multiselect stored.

Before I deleted the Multiselect custom field which contained no values, I then renamed the cascading select custom field to the same name as the other custom field i.e. FSiAvailability Section, deleted the multiselect custom field, this some how deleted all the options and values of the cascading select

7 answers

1 accepted

Accepted Answer
1 vote

You might want to raise this as a proper support call if you need full support - we're just a community of end-users. We'd love to help, but we are not support.

I'm afraid though, it sounds like you picked the wrong field when you hit "delete" - even if fields have the same name, they aren't related, it's all done on unique IDs in the database.

I'm also afraid there's not a lot of choice about restoring the data. I would NOT restore directly, but I would fire up a dev/test Jira, restore it in there and then use it to work out where you've removed the data from the issues, then you'll be able to put it back (I'd use bulk edit for this, or even think about Jelly scripting)

I am tring to copy over some of the deleted values from a restore on my test system to my live syste, i copied over custom field value and custom field option for the deleted custom field, but the system is not recognising them. I think this is something to do with custom field config any ideas?

How are you doing the copy? Have you started with the list of options for the field before starting on the issues?

I restored this mornings database copy to a test jira application, opened the sql database and copied the values from the test databse tables over to my live jira database tables in microsoft sql server , using copy and paste

You did have Jira offline when you did this for the options?

More importantly, did you do this with the field values for issues as well?

No it wasnt off line should i restart? and yes i did it with the field values also

I just told all my users to stop using the system until further notice

I managed to resolve this by adding a new option inteh application this gave me a new custom field config value, when I then reset all my old valoues with the new custom field config value all the old values were restored to the new cascading select custom field

0 votes

Ah, yes, well done.

The application caches data while it's running, so if you mess with the database, it doesn't pick up changes. Adding an option via the UI prompts it to reread everything

Generally, if you're going to use SQL to amend Jira data, it's essential that you shut it down first. In the case of field options, you might get away with it!

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 18, 2018 in Jira

What modern development practices are at the heart of how your team delivers software?

Hey Community mates! Claire here from the Software Product Marketing team. We all know software development changes rapidly, and it's often tough to keep up. But from our research, we've found the h...

25,438 views 2 7
Join discussion

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you