要約

There are scenarios where the Default Field Configuration has too many custom fields that need to be hidden.

Clicking the Hide button several times can be done on a few custom fields, but if there are hundreds or thousands of custom fields to hide, a viable option would be to do it using database queries instead.

環境

Tested on Jira 8.13.

ソリューション

Hiding multiple custom fields in a field configuration can be done using direct database updates.

Changes to Field configurations from the database side will only show up on the UI after a restart of Jira.

1. Find the ID of the fieldlayout you want to modify. Review the contents of this table to do so:

   select * from fieldlayout;

2. You may follow up with this query to see what is available on this field layout:

   select * from fieldlayoutitem where fieldlayout in (<fieldlayoutid>);

3. This query will hide necessary custom fields instead on the database. This query was tested on a PostgreSQL database for the field configuration with <fieldlayoutid>. You'll still need to have a pattern for the custom fields you want to hide or alternatively you may replace the last line below with fieldidentifier in ('fieldname1','fieldname2','fieldname3') .

   update fieldlayoutitem
   set ishidden = 'true'
   where fieldlayout = <fieldlayoutid>
   and fieldidentifier like '%customfield%';
   

4. The change won't show up on the UI until a restart of Jira is done. However, the field configuration can be copied to a new field configuration. The new field configuration would have the custom fields hidden as a result.