nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get all comments list in confluence via SQL queries

Lakshman_iaa65w

Accepted answers

Davin Studer

This should get you the comments from the database.

select *
from [CONTENT] C
inner join [BODYCONTENT] B on C.CONTENTID = B.CONTENTID
where
    C.CONTENTTYPE='COMMENT'
    and PREVVER is null
    and CONTENT_STATUS = 'current'

All comments

Davin Studer

This should get you the comments from the database.

select *
from [CONTENT] C
inner join [BODYCONTENT] B on C.CONTENTID = B.CONTENTID
where
    C.CONTENTTYPE='COMMENT'
    and PREVVER is null
    and CONTENT_STATUS = 'current'

Lakshman_iaa65w

Thanks for your query it woks!!!

Davin Studer

Glad to help! Please make sure to mark the question as answered. Thanks.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence