We have migrated from JIRA 4.3 to 6.2 and we are lost some custom fields values during this process.
For example, project name ABC, field name - Severity, values - from 0 to 5.
After migration all values set to 'none'.
How can I get: issue numbers, for custom field name 'Severity' (with CF values) for project ABC from old database (SQL query)?
thanks for your answer.
The migration was performed by our partners and I don't know the details. Unfortunately I have no contact with this guy for some reason, and I must resolve this issue by myself. Also, the old JIRA instance (4.3) currently down, so I have access to the database only...
Oh dear. You could be in a lot of trouble here. It sounds like your partner has botched your upgrade. There's no real way to rescue that other than go back to 4.3 and re-do it properly. Attempting to recreate bits of the data might help get it back, but it's going to be very hard work and you still don't know what else is missing. Your field data is kept in customfieldvalue in the database, but you'll need to join that to jiraissue to establish which issues the data is linked to, and customfield to work out what the field type is and how to read it. Note - I can NOT recommend trying to wedge it back in using SQL, you really need to be doing it manually with bulk-edit, the CLI plugin, Jelly or REST scripts of some sort. But I'd be trying to find your partner to find out why they've messed this up and get them to fix it properly.
I don't think there's an easy way to do this. The structure of the data around custom fields has not changed hugely from 4 to 6, so if you write the SQL to fetch data from the old 4 database using the tables and joins I mentioned before, you can use the same SQL to extract from the 6 database, so that's your starting point. But you've still got the howling problem that you don't know what else might be broken.
In the past, Portfolio for Jira required a high degree of detail–foresight that was unrealistic for many businesses to have–in order to produce a reliable long-term roadmap. We're tur...
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
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs