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
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?
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!
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!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG