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??
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
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%';
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Fabby ,
User properties are stored in database in the 'propertyentry' table
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Fabby,
Could you plase specify what kind of user property that you are looking for?
Cheers,
Septa Cahyadiputra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.