In which database table do I find translations for statuses and resolutions?

[Gisela Lassahn]

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

[Gonchik Tsymzhitov]

Hi! 

did you figure out? 

[Gisela Lassahn]

No, unfortunately, I didn't.