I would like to know where in the Jira database the translations of statuses and resolutions are stored and how I can query statuses and resolutions with their translations.
I know the tables "issuestatus" and "resolution" (and how to link them with table "jiraissue"), but there I don't find the translations.
I've just found out that I get some of the translations like this:
SELECT s.pname, pe.PROPERTY_KEY, ps.propertyvalue
FROM issuestatus s, propertyentry pe, propertystring ps
WHERE pe.ENTITY_NAME = 'Status'
AND pe.ID = ps.ID
AND s.id = pe.ENTITY_ID
But is there a chance to get a list of the statuses (or resolutions) with their translations which are hidden in the language packs without an AddOn where we have to pay for?
(We use Jira Data Center. I don't know if that makes any difference.)
