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.

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

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'



DescriptionHow to find User's "Configure Fields" custom settings using database query
ProductJira Core, Jira Service Management, Jira Software

Last modified on Aug 2, 2022

Was this helpful?

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