nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to find User's Language in Jira

Piyal Nanayakkara

We need to get the statistics of Language (visible in Profile ) used by Jira users.

What is the Database table and Field storing User's language?

Regards

Piyal

Accepted answers

Fabio Racobaldo _Catworkx_

Hi @Piyal Nanayakkara ,

please use the following query to retrieve info about language user preferences :

select u.user_key, PROPERTY_KEY, propertyvalue 
from propertyentry pe 
join app_user u on u.id = pe.entity_ID
join propertystring ps on ps.id = pe.id and property_Key = 'jira.user.locale';

Hope this helps,

Fabio

All comments

Fabio Racobaldo _Catworkx_

Hi @Piyal Nanayakkara ,

please use the following query to retrieve info about language user preferences :

select u.user_key, PROPERTY_KEY, propertyvalue 
from propertyentry pe 
join app_user u on u.id = pe.entity_ID
join propertystring ps on ps.id = pe.id and property_Key = 'jira.user.locale';