How to keep data when Questions for Confluence app license expires
Platform Notice: Data Center - This article applies to Atlassian products on the Data Center platform.
Note that this knowledge base article was created for the Data Center version of the product. Data Center knowledge base articles 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
Suppose you have a subscription to the Questions for Confluence app in your instance and would like to cancel it for any reason. In that case, you might wonder what happens to the app and its data after the license expires and how to keep historical data after that for documentation.
Environment
- Confluence Data Center
- Questions for Confluence app
Cause
Once the app's license expires, it will still be usable in your UI for some time until one of the following happens:
- Confluence is restarted, or;
- The app is disabled in the instance, or;
- The license is removed from the app.
After one of these situations, the app will disappear from the UI, and the historical data will not be accessible in Confluence.
Solution
We have some options for retrieving the historical data of the Questions for Confluence app after its license expires.
Database
This process requires the use of direct database manipulation and is not part of Confluence's intended functionality. As such, this process is not covered under the Atlassian Support Offerings and the information on this page is provided as-is. It should be thoroughly tested in a development or staging environment before implementing any changes in your production instance.
One option to retrieve this data would be to use SQL to query this information stored in the Confluence database.
The Q&A stores data in following tables:
- AO_B1DBB9_ACCEPTANCE
- AO_B1DBB9_BOUNTY
- AO_B1DBB9_VOTE
- CONTENT
- BODYCONTENT
All questions can be found using this query:
SELECT * FROM %YOURCONFLUENCEDBNAME%.CONTENT
where PLUGINKEY in
('com.atlassian.confluence.plugins.confluence-questions:question');
All answers can be fetched using this query:
SELECT * FROM %YOURCONFLUENCEDBNAME%.BODYCONTENT b
where b.CONTENTID in (
SELECT a.CONTENTID FROM %YOURCONFLUENCEDBNAME%.CONTENT a
where a.PLUGINKEY in
('com.atlassian.confluence.plugins.confluence-questions:answer'));
You can also export all information into CSV by following this KB:
How to export Confluence Questions Content to CSV Through the Database