How to find User's "Configure Fields" custom settings using database query
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Summary
Purpose
On the Jira Create issue screen, each users can customize which fields will appear every-time they create an issue.
Click Create button.
Click on Configure Fields > Click Custom
When a Jira user customizes the configure settings an entry is created in the propertyentry table. This KB article is meant to provide a query to find which user(s) has/have a customized Configure Fields setting and which fields are checked by those users.
Solution
Find which user has a Customized Configure Fields setting:
1
2
3
4
5
6
7
8
select *
from app_user e,
propertyentry pr,
propertynumber pn
where pr.entity_id = e.id
and pn.id = pr.id
and pr.property_key = 'jira.quick.create.use'
and pn.propertyvalue = '1'This will list out all of the user that has a customized Configure Fields settings.
Find which fields are checked by a specific user:
1
2
3
4
5
6
7
8
select *
from app_user e,
propertyentry pr,
propertytext pt
where e.lower_user_name = '<Replace_with_specific_user_name_in_lower_case>'
and pr.entity_id = e.id
and pt.id = pr.id
and pr.property_key = 'jira.quick.create.fields'This will list which fields are checked by the specific user when they click on Configure Fields > Custom under propertyvalue column.
Find which fields checked by ALL of the users in Jira:
1
2
3
4
5
6
7
select *
from app_user e,
propertyentry pr,
propertytext pt
where pr.entity_id = e.id
and pt.id = pr.id
and pr.property_key = 'jira.quick.create.fields'Was this helpful?