Managing Field Visibility in JIRA: How to Ensure All Fields on Screens are Visible in FieldConfig

adminUncategorized

jira-migration1-1

Creating a project configuration with over 500 custom fields can be a daunting task in JIRA. To simplify the process and avoid potential errors, a more efficient approach is required for managing field visibility.

This short article explores a simple query-based solution that ensures each field on a screen is visible in the corresponding field configuration, making project configuration in JIRA less complex and more streamlined.

Here is the query – hopefully, useful for someone :

select fss.NAME,  cf.cfname
from fieldscreen fss
inner join fieldscreentab fst on fst.FIELDSCREEN = fss.id
inner join fieldscreenlayoutitem fsl on fsl.FIELDSCREENTAB = fst.ID
inner join fieldlayoutitem fli on fli.FIELDIDENTIFIER = fsl.FIELDIDENTIFIER
inner join fieldlayout fl on fli.FIELDLAYOUT = fl.ID
left join customfield cf on cf.ID = cast(SUBSTRING(fsl.FIELDIDENTIFIER,13,20) as integer)
where fss.NAME like 'PTR_%'
and fl.NAME like 'PTR_%'
and fli.ISHIDDEN = 'True'

 

Used on line
Table
Used for
3fieldscreenThis table lists all the screens of the configuration
4fieldscreentabeach screen can have multiple tabls
5fieldscreenlayoutitemthis is the actual table containing an entry for each screen object
6fieldlayoutitemthe fieldlayoutitem are the entries in the field configuration
9,10Limit the query to the screens of interest. As we are using a prefix type of scheme it is easy to select the right screens
11Show all entries which are marked as hidden in the field configuration

 

If you need support, contact us. We’d be happy to help.