Custom Field - lost data after migration

Question

Hello,

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)?

Many thanks!

Todd Hlavacek · Answer

Posted a similar issue over here... https://answers.atlassian.com/questions/9389045  Posting in case the answer pops up over there that may help people searching for this particular issue.

Nic Brough -Adaptavist- · Answer

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.

Serge5 · Answer

Yep, I know that this is a big problem :(
 But I just want to see which issues losing their values, to start with something. Unfortunately I'm not a big expert on mysql, so I don't know how to do this correctly...