Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The Power Admin page shows the same Rank custom field as locked.

...

Environment

Component

Server/Data center

Application

Power Admin

Database Type

N/A

Cause

The KB article https://confluence.atlassian.com/jirakb/unlock-a-locked-jira-software-custom-field-779158866.html used to ‘unlock’ the fields suggests changing the managed field in the managedconfigurationitem table from ‘true’ to ‘false’ for the field that needs to be unlocked. However, some applications (including Power Admin) still treat the field as locked since they use the actual access_level specified in another field in the same table.

Solution

  1. Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.

  2. To unlock the field to change with Power Admin, follow the

...

  1. steps

...

  1. listed in the KB article (https://confluence.atlassian.com/jirakb/unlock-a-locked-jira-software-custom-field-779158866.html)

...

  1. Also, change the value of the access_level field to ‘ADMIN’

...

  1. .
    UPDATE managedconfigurationitem set ACCESS_LEVEL='ADMIN' where item_id in ('customfieldID');

  2. Make the required changes to the fields.

  3. Lock the fields that were unlocked by setting the managed column to true. For example, the below will lock the Ranking custom field.

    Code Block
     UPDATE managedconfigurationitem set managed='true' where item_id in (<customfield_id>);
     UPDATE managedconfigurationitem set ACCESS_LEVEL='

...

  1. LOCKED' where item_id in ('customfieldID');

Info

These fields will be locked again on startup by automated tasks within plugins.