Jira Screen not displaying fields as expected
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. 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
Summary
Opening a screen in Jira is not showing expected fields.
This can happen when opening, creating or editing an issue.
Can also happen in the Bulk Edit screen.
Cause
One or more fields have a script that is either misconstructed or actively hiding other fields.
The following SQL query can search for any field with scripts in it covering 3 different places this can be added, Custom Field description, Field description in screens, Default value in field's context.
1
2
3
4
5
6
7
8
select distinct CF.cfname, CF.description as "Custom field description", FLI.description as "Custom field screen description", GC.xmlvalue as "Context default value"
from customfield CF
left join fieldlayoutitem FLI on FLI.fieldidentifier = 'customfield_'||CF.id
left join configurationcontext CC on CC.customfield = 'customfield_'||CF.id
left join genericconfiguration GC on cast(CC.fieldconfigscheme as varchar) = GC.datakey
where CF.description like '%<%'
or FLI.description like '%<%'
or GC.xmlvalue like '%<%';
Query above is looking for the "<" character only, so it may bring false positives.
Please note SQL query above was built in PostgreSQL and may require some change to work on other DBMS
Solution
Review all scripts returned by the query above and fix or remove them
Was this helpful?