Remove existing Confluence "mentioned in" links in Jira
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles for non-Data Center-specific features may also work for Server versions of the product, however they have not been tested. 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.
*Except Fisheye and Crucible
Summary
Currently, Jira does not have a way to disable Confluence mentioned in issue links selectively. The two permanent options available are:
- Disabling issue linking entirely, as described on Configuring issue linking.
- Removing the Confluence application link, as described on Link to other applications.
Several Jira Administrators have requested more granular remote issue link controls on JRASERVER-64952 - Create way to bulk-remove links of a specific link-type
This guide describes how to remove existing Confluence mentioned in issue links. This approach also applies to other applications supporting remote issue links, such as GitLab.
Environment
Jira 5.0 or later.
Confluence or another application that supports remote issue links.
Solution
1. Search for issue links
From your database, run the following statement to query the number of remote issue links to be deleted:
SELECT COUNT(*) FROM remotelink WHERE relationship = 'mentioned in' AND url LIKE '<confluence-base-url>/%';
Replace <confluence-base-url> with the base URL of the linked application (for example, LIKE 'https://confluence.atlassian.com/%';). Be sure to leave the trailing slash and percent sign wildcard.
Confluence uses mentioned in as the relationship name. However, other applications may use different names – such as mentioned on in the case of GitLab. The remote application, not Jira, decides the relationship name.
To get more details on the remote issue links, replace COUNT(*) with *.
2. Delete issue links
Always back up your data before performing any modifications to the database. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
After verifying the changes, use this DELETE statement to delete the remote issue links. Substitute the relationship and URL to match the previous SELECT query.
DELETE FROM remotelink WHERE relationship = 'mentioned in' AND url LIKE '<confluence-base-url>/%';