How to capture storage format for Confluence Question
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the server and data center platforms.
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.
- Confluence Question v. 2.7.34
- Confluence v 7.13.0
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:
Use this query to get storage format for question and all answers under it
SELECT 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.