How to find User's "Configure Fields" custom settings using database query

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform Notice: Server and Data Center Only - This article only applies to Atlassian products on the server and data center platforms.

Purpose

On 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 the customer customize the configure settings an entry are created under propertyentry table. This KB is to provide a query to find which user has a customize 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 customize Configure Fields settings.

Find which fields checked by the specific user:

select *
from app_user e,
propertyentry pr,
propertytext pt
where e.user_key = '<Replace_with_specific_user_key>'
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 user 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'



DescriptionHow to find User's "Configure Fields" custom settings using database query
ProductJira Core, Jira Service Management, Jira Software
Last modified on Nov 23, 2020

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.