症状

After creating Service Management for existing projects, old issues created before the Service Management creation date were not converted to Service Management requests.

原因

Request type is not specified

 Jira Service Management requests are Jira issues that:

1. Are in a Jira Service Management enabled project.
2. 有効なカスタマー リクエスト タイプ (またはリクエスト タイプ/サービス管理リクエスト タイプ) がある。

Currently Jira Service Management doesn't convert the existing issues to requests automatically. The improvement ticket is tracked over here:  JSD-55 - Getting issue details... STATUS

回避策

Convert issues to Jira Service Management requests by adding request types. 

要約

1. Determine what issues do not have request types. 

2. Obtain proper format for request types from the database.

3. Add request type to affected issues using Jira Suite Utilities. The steps below will need to be performed for each request type.

詳細な手順:

1. Run the following JQL in the advanced search within Jira:
   
   

   JQL

   project = XXXX AND "Customer Request Type" is EMPTY

2. Install the third party add-on Jira Suite Utilities.

3. The database query below will return the results of the project key and the request type.

   
   

   select vp."KEY" as "project-key",vpf."KEY" AS "request-type" from "AO_54307E_VIEWPORT" vp join "AO_54307E_VIEWPORTFORM" vpf on vpf."VIEWPORT_ID" = vp."ID";

   Query syntax formatting may need to be adjusted

   The syntax above is written for Postgres. It may need to be adjusted for other database engines.
4. Go to the workflow used by the affected project.
5. Create a temporary transition named "Set Customer Request Type" and map to the same status (or any other status you prefer).
6. In the transition, go to the Post Function tab.

7. Add a post function Update Custom Field with following values:

   project-key/request-type

8. Save the workflow or publish the draft.
9. Run the following JQL in Advanced Search: Replace XXX with your prefer project. For better result, include the issuetype to ensure the issues set to the right request type.
10. In Issue Navigator, choose Tools >> Bulk Operation.
11. From the list of operations, select "Transition Issues".
12. Select the transition "Set Customer Request Type"
13. Finish the operation.
14. The temporary transition can be removed from the workflow after the operation is completed.