does user property value store in database ?

fabby July 30, 2012

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??

5 answers

1 accepted

4 votes
Answer accepted
Septa Cahyadiputra
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 30, 2012

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 July 30, 2012

thanks all of you!

1 vote
Gregory Kneller
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 20, 2015

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%';
1 vote
Mizan
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 30, 2012

Hi Fabby ,

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

0 votes
fabby July 30, 2012

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

0 votes
Septa Cahyadiputra
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 30, 2012

Hi Fabby,

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

Cheers,
Septa Cahyadiputra

Suggest an answer

Log in or Sign up to answer