How to capture storage format for Confluence Question

Still need help?

The Atlassian Community is here for you.

Ask the community


Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

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

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.

Summary

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.

  1. Open question in the web browser and take note of Content ID in URL:

    http://confluence:27130/questions/[content_id]/question_asked_here
  2. 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;

    (info) The query above was tested on PostgreSQL, adjustments might be needed to used on a different DBMS.


Last modified on Nov 19, 2021

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.