does user property value store in database ?

[fabby]

my jira version is jira 4.4.1.

i try to find something about user property in database,but without luck.

so i wonder if the data isn't stored in database,or it is stored in some files like xml??

[Septa Cahyadiputra · Accepted solution]

Hi Fabby,

Here is the SQL query to listed all the user properties stored on your database and the users its associated too

SELECT
e.Name,
t.property_key,
s.propertyvalue as FieldValue
FROM
external_entities e
JOIN propertyentry t
ON
e.ID = t.entity_id
JOIN propertystring s
ON
t.ID = s.ID
where t.property_key like 'jira.meta%';

Hope it helps.

Cheers,
Septa Cahyadiputra

[fabby]

thanks all of you!

[Gregory Kneller]

Changed in  JIRA 6

SELECT
e.user_key,
t.property_key,
s.propertyvalue as FieldValue
FROM
app_user e 
JOIN propertyentry t
ON
e.ID = t.entity_id
JOIN propertystring s
ON
t.ID = s.ID
where t.property_key like 'jira.meta%';

[Mizan]

Hi Fabby ,

User properties are stored in database in the 'propertyentry' table

[fabby]

hi,Septa

it's a property for User.

for example,we can add phone number or address for one user.

https://confluence.atlassian.com/display/JIRA/Managing+Users

[Septa Cahyadiputra]

Hi Fabby,

Could you plase specify what kind of user property that you are looking for?

Cheers,
Septa Cahyadiputra