How to retrieve custom User Properties in JIRA?

[Daniel Micallef]

I have added a number of properties to various users (via User>Actions>Edit Properties) and aim to use these properties in a mail handler plugin.

These properties are shown in the User page as per below:

and could also be retrieved from the DB via

select *
  from propertyentry pe,
    propertystring ps,
    app_user au
  where pe.ID = ps.ID
    and au.ID = pe.ENTITY_ID
    and PROPERTY_KEY like 'jira.meta.%'

However I am unable to retrieve these properties using UserPropertyManager (as per below):

UserPropertyManager userPropertyManager = ComponentAccessor.getUserPropertyManager();
PropertySet ps = userPropertyManager.getPropertySet(appUser);

The following output shows that the manually added properties are not displayed:

Collection<Object> keys = ps.getKeys();
for (Object key : keys) {
    LOG.debug("Property key   -> " + (String) key + "; Value -> " + ps.getAsActualType((String) key));
}

Therefore, how can I retrieve the manually added user properties in my JIRA plugin (Note that this is JIRA 6.3).

[Gaston Valente]

Daniel,

Did you try with UserPreferencesManager?

Hope it helps

[Daniel Micallef]

Gaston,

Is it possible to print all items and values of Extended Preferences?

Thanks