Locating and Modifying Jira Application Links in Database
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
Summary
The following query will display all OAuth 1.0a application links in Jira's database:
1
2
3
4
5
6
7
SELECT pe.id AS property_id,
pe.property_key AS property_key,
ps.propertyvalue AS property_value
FROM propertyentry pe
JOIN propertystring ps ON pe.id = ps.id
WHERE pe.property_key LIKE 'applinks%'
ORDER BY pe.id;OAuth 2.0 application links can be found in the AO_FE1BC5_* tables.
It is not recommend to modify Jira application links directly in the database.
If you're changing hostnames and need to update the relating application links in Jira:
Delete the existing application links in the UI
Create new application links with the new hostnames.
In Jira, update Confluence page links
In Confluence, update Jira issue macros and short links
Was this helpful?