How to clean up data from the Questions for Confluence app
プラットフォームについて: Server および Data Center のみ。この記事は、Server および Data Center プラットフォームのアトラシアン製品にのみ適用されます。
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.
*Fisheye および Crucible は除く
目的
If you chose to uninstall the Question for Confluence app via the Universal Plugin Manager (UPM), the data/configuration created by the app stored in the database will remain in the database, this is by design as the app and its data are stored separately in the database.
If you wish to remove the app and all its data for good, it can only be achieved by manual database deletion. Please see the list of queries below:
ソリューション
First, data such as Votes, Acceptance, and Bounty are stored individually in the following tables:
- AO_B1DBB9_ACCEPTANCE
- AO_B1DBB9_BOUNTY
- AO_B1DBB9_VOTE
データベースの変更を行う場合は必ず事前にバックアップを取得してください。可能な場合は、まずステージング サーバーで SQL コマンドの変更、挿入、更新、または削除を行うようにします。
Drop the tables above via the queries below:
DROP TABLE AO_B1DBB9_ACCEPTANCE;
DROP TABLE AO_B1DBB9_BOUNTY;
DROP TABLE AO_B1DBB9_VOTE;
Next, the Questions for Confluence app also writes into general tables such as "CONTENT", "BODYCONTENT", "LABEL" and "CONTENTPROPERTIES", which are tables for Confluence to store page-related data. In order to filter out data exclusive to the Questions app, you can use the queries below:
SELECT * FROM CONTENT where PLUGINKEY LIKE '%com.atlassian.confluence.plugins.confluence-questions%';
All data queries from the SELECT query above are expected to consist of records such as Question, Answer, Comment, and Topic. Delete the data (and its reference) via the queries below:
DELETE FROM CONTENTPROPERTIES WHERE CONTENTID IN (SELECT CONTENTID FROM CONTENT where PLUGINKEY LIKE '%com.atlassian.confluence.plugins.confluence-questions%');
DELETE FROM BODYCONTENT WHERE CONTENTID IN (SELECT CONTENTID FROM CONTENT where PLUGINKEY LIKE '%com.atlassian.confluence.plugins.confluence-questions%');
DELETE FROM CONTENT_LABEL WHERE CONTENTID IN (SELECT CONTENTID FROM CONTENT where PLUGINKEY LIKE '%com.atlassian.confluence.plugins.confluence-questions%');
DELETE FROM LABEL WHERE LABELID IN (SELECT LABELID FROM CONTENT_LABEL WHERE CONTENTID IN (SELECT CONTENTID FROM CONTENT where PLUGINKEY LIKE '%com.atlassian.confluence.plugins.confluence-questions%'));
DELETE FROM CONTENT where PLUGINKEY LIKE '%com.atlassian.confluence.plugins.confluence-questions%';