Knowledge Base searches still use the old Application Link URL on the Customer Portal
After changing the URL of the Confluence Application Link, the knowledge base links on Jira Service Management still points to the old URL. We're tracking this a bug on - JSD-641Getting issue details... STATUS .
Simply run the following SQL query in Jira's database to verify which is the URL in use by JSD:
SELECT * FROM "AO_54307E_CONFLUENCEKB";
Always backup Jira before modifying its database.
- Stop Jira;
- Update the
AO_54307E_CONFLUENCEKBtable, and update the application link URL.
- Restart Jira;
For example, if updating the URL from HTTP to HTTPS, the following can be used:
This was created using PostgreSQL - if you're using a different DBMS you may need to update the query accordingly.