Remove existing Confluence "mentioned in" links in Jira

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

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:

Several Jira Administrators have requested more granular remote issue link controls on JRASERVER-64952 - Getting issue details... STATUS

This guide described how you can remove existing Confluence mentioned in issue links. This approach 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

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>/%';

(info) 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.

(info) 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.

(lightbulb) To get more details on the remote issue links, replace COUNT(*) with *.

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>/%';

Last modified on May 5, 2023

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.