How to rename SLAs
プラットフォームについて: Data Center - この記事は、Data Center プラットフォームのアトラシアン製品に適用されます。
このナレッジベース記事は製品の Data Center バージョン用に作成されています。Data Center 固有ではない機能の Data Center ナレッジベースは、製品のサーバー バージョンでも動作する可能性はありますが、テストは行われていません。サーバー*製品のサポートは 2024 年 2 月 15 日に終了しました。サーバー製品を利用している場合は、アトラシアンのサーバー製品のサポート終了のお知らせページにて移行オプションをご確認ください。
*Fisheye および Crucible は除く
要約
Currently, there is no way to rename SLAs in Service Management. However, this can be achieved via direct database modification.
This example explains how to rename an SLA from SLA1 to SLA2 in a Service Management with project key SD.
手順
Direct database modification is not supported. Please make sure to back up your database or create an XML backup in Jira before attempting this workaround.
- Jira を停止します。
Identify the ID of the SLA custom field (notice the use of SLA1 as the name of the SLA custom field):
select ID, cfname from customfield where customfieldtypekey like '%sla%' and cfname = 'SLA1';By default, this custom field is Locked and has the same name as the SLA.
Identify the ID of the Service Management (notice the use of SD as the project key of the Service Management):
select ID from ao_54307e_servicedesk where project_id = (select ID from project where pkey = 'SD');As the same SLA can be used in multiple service projects, it's good to make sure that you only change its name where necessary.
Identify the SLA itself:
select ID, name from ao_54307e_timemetric where custom_field_id = <ID_from_query_1> and service_desk_id = <ID_from_query_2>;It should have the same name as the SLA custom field, which is SLA1 in this case.
To ensure the changes are reflected on (Jira Administration > Issues > Custom Fields) and JQL filters.
update customfield set cfname = 'SLA2' where customfieldtypekey like '%sla%' and cfname = 'SLA1';Once you're sure this is the SLA you'd like to rename, rename it (notice the use of SLA2 as the new name):
update ao_54307e_timemetric set name = 'SLA2' where ID = <ID_from_query_3>;- Start Jira upon executing the queries.
There is a feature request for this functionality to be native to Service Management at: