Where does Confluence store comments in the database?

Still need help?

The Atlassian Community is here for you.

Ask the community

Confluence store comments, like contents of a page, in the BODYCONTENT table.

It's referred to the CONTENT table which stores the metadata of each comment (such as creator, the page where it belongs, etc)

For example, the following SQL query is to retrieve all comments in Confluence:

SELECT *
FROM BODYCONTENT
WHERE CONTENTID IN (
   SELECT CONTENTID
   FROM CONTENT
   WHERE CONTENTTYPE = 'COMMENT'
);


Related content:

Last modified on Apr 11, 2019

Was this helpful?

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