Hi Team,how to fetch the JIRA properties added from UI

[Shrikant Maheshwari]

Hi Team, how to fetch the JIRA properties added from UI.

• https://developer.atlassian.com/cloud/jira/platform/rest/v3/#api-api-3-user-picker-get

The above documentation does not help in fetching the JIRA properties added from UI. I have created some JIRA user properties but unable to fetch them using the rest API.
Or is there any way to get the JIRA properties details added from UI may be from JQL or Export etc ?

[Stephen Sifers]

Hello Shrikant,

Setting additional user properties can be very useful when setting up or adjust workflows to be more customized.

Please note that within the API when accessing user properties the following is stated:

Note: These user properties are unrelated to the Jira properties that can be set through the UI.

Source: Get user property

There was as a similar question asked on how to extract user properties from the database for Jira Server. The following was reported as a working solution (Confirmed the top statement works on Jira 7.12.3):

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.%'

For Jira below 6.0 use the following select statement.

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

Credits to @Tiago Comasseto

Source post:  How to find User Properties in Jira database?

Please let us know if this allows you to access the additional User properties you are looking for.

Regards,
Stephen Sifers