How to capture storage format for Confluence Question
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
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.
On some occasions it might be necessary to get the storage format of Confluence question or answers.
You can get Confluence Storage Format for Confluence pages from WebUI, but Confluence Questions do not have this option, so you need to pull it directly from DB.
Environment
Tested with
Confluence Question v. 2.7.34
Confluence v 7.13.0
Solution
You can pull storage format directly from the database following these instructions.
Open question in the web browser and take note of Content ID in URL:
1http://confluence:27130/questions/[content_id]/question_asked_hereUse this query to get storage format for question and all answers under it
1 2 3 4 5 6 7SELECT c.pluginkey AS type, b.body AS storage_format FROM bodycontent AS b JOIN content AS c ON b.contentid = c.contentid WHERE [content_id] IN(c.contentid, c.parentccid) AND c.content_status='current' ORDER BY c.pluginkey DESC;ℹ️ The query above was tested on PostgreSQL, adjustments might be needed to used on a different DBMS.
Was this helpful?