JIRA Software- SQL Query for statuses and translation / for custom fields and translation

Question

Hello,

I want to query  JIRA Software database with SQL query to have :

- workflow statuses and their translation,

- custom fields and their translation.

I found tables :

- issuestatus

- customfield

but, I don't find link to translation tables.

Could you please help me.

Thanks.

Best regards,

Sébastien Lucchini.

Sébastien Lucchini · Answer

Hello Petterson,

Thank you.

I don't find entity_translation table but I find query :

select CF.cfname, CF.description, PE.entity_name, PE.PROPERTY_KEY, PS.PROPERTYVALUE
from customfield CF, propertyentry PE, propertystring PS
where CF.id = PE.entity_id
and PE.id = PS.id
and PE.entity_name in ('CustomField')
order by 1, PE.PROPERTY_KEY

I'm looking for translation for statuses.

Best regards,

Sébastien Lucchini

Petter Gonçalves · Answer

Hello Sébastien,

- For custom field translations, you can check the table entity_translation

- For Statuses translations, you can check the properties tables, as mentioned by @Nic Brough -Adaptavist- in this post:

https://community.atlassian.com/t5/Jira-questions/How-to-translate-results-and-status-in-jira-database/qaq-p/171207