Purpose

On the Jira Create issue screen, each users can customize which fields will appear every-time they create an issue.

1. Click Create button.
2. 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:

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:

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:

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'