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

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: Server と Data Center のみ - この記事は、サーバーおよびデータセンター プラットフォームのアトラシアン製品にのみ適用されます。

目的

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.

ソリューション

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'



説明How to find User's "Configure Fields" custom settings using database query
製品Jira Core, Jira Service Management, Jira Software
最終更新日 2020 年 11 月 23 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.