Add and update new link type.

[Ashwini Nadagoud]

Currently we have the default "relates to" link being used and we have identified 200k+ relationships in this scope. We would like to create a new link type and convert all 200k+ to the new link type. We are concerned using the API would result in a conversion would take multiple days. We were considering the database update directly but that method is not recommended. Does anyone know a safe and faster way for this process? There are other "relates to" links that do not need to be converted.

[Fabio Racobaldo _Catworkx_]

Hi @Ashwini Nadagoud ,

welcome to the Atlassian community.

Changes at DB level could impact JIRA. So, please, before any changes test it in a test environment.

BTW, the operation should be :

1. Create a new link type https://confluence.atlassian.com/adminjiraserver/configuring-issue-linking-938847862.html
2. Retrive link type id (go to Edit after creation and you should be able to retrive ID in the browser URL)
3. Run the following query update issuelink set LINKTYPE=YOUR_LINK_TYPE_ID_HERE where SOURCE IN (ISSUES_ID_LISTS_HERE); 

SOURCE is the ID of issues in jiraissue table.

After this change you need to restart your JIRA instance.

Hope this helps,

Fabio

[Ashwini Nadagoud]

Thank you Fabio. I will try this method and see how it goes.

[Sebastian Krzewiński]

HI @Ashwini Nadagoud 

After migration "relates to" will be deleted or will be still used?

Regards,

Seba

[Ashwini Nadagoud]

It will be used by relations that do not require a new link type.