Identifying which space is integrate with Application Link
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs 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
Problem
User will be seeing the following statement when deleting application link especially 1 link from confluence space to JIRA projects will be deleted. The user are not sure which space is linked with JIRA project.
Diagnosis
Environment
Application link are created between Confluence and Jira
Confluence space are integrated with JIRA Project
Workaround
You need to run the following query in order to identify which space are linked with JIRA project.
1SELECT * FROM BANDANA WHERE BANDANAKEY LIKE '%space.linked.entities%';After running the above query you will be getting the following output (example) under the table BANDANAKEY. The space key will be after applinks.local.
1applinks.local.TEST.confluence_space.linked.entitiesThe output will provide the space key of the space that linked with the JIRA project, in this example it will be TEST.
After getting the space key, please run the following query in your database to identify which space is linked with JIRA project.
1SELECT SPACENAME FROM spaces where spacekey='TEST';
Was this helpful?