要約

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.

環境

Tested with

• Confluence Question v. 2.7.34
• Confluence v 7.13.0

ソリューション

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;

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