Add and update new link type.

Question

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.

Ashwini Nadagoud · Answer

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

Fabio Racobaldo _Catworkx_ · Answer

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 :

* Create a new link type https://confluence.atlassian.com/adminjiraserver/configuring-issue-linking-938847862.html
* Retrive link type id (go to Edit after creation and you should be able to retrive ID in the browser URL)
* 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 · Answer

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