How to rename SLAs

お困りですか?

アトラシアン コミュニティをご利用ください。

コミュニティに質問

プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。

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.

*Fisheye および Crucible は除く

Currently there's no way to rename SLAs in Service Management. However, this can be achieved via direct database modification.

tip/resting Created with Sketch.

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.


  1. Jira を停止します。
  2. 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

  3. 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

  4. 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

  5. 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'; 
  6. 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>;


  7. Start Jira upon executing the queries.

There is a feature request for this functionality to be native to Service Management at:  JSD-119 - Getting issue details... STATUS

最終更新日 2022 年 8 月 22 日

この内容はお役に立ちましたか?

はい
いいえ
この記事についてのフィードバックを送信する
Powered by Confluence and Scroll Viewport.