How to clean up data from the Questions for Confluence app
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
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:
Solution
First, data such as Votes, Acceptance, and Bounty are stored individually in the following tables:
AO_B1DBB9_ACCEPTANCE
AO_B1DBB9_BOUNTY
AO_B1DBB9_VOTE
Always back up your data before making any database modifications. If possible, test any alter, insert, update, or delete SQL commands on a staging server first.
Drop the tables above via the queries below:
1
2
3
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:
1
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:
1
2
3
4
5
6
7
8
9
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%';Was this helpful?