how to find pages that have comments

How can I find pages that have comments ?

I know you can subscribe to a space (watch), but this will only notify me of new comments and I would like to see pages that have old comments as well.

Is there a macro trick to give me a summary of pages in a space that have comments attached ?

3 answers

You can find all comments by searching for type:comment. This will also give you all pages that have comments, but the question is what you want to do with these pages.

We have a space where only a few accounts have rights to create/edit pages but everyone can add comments to suggest improvements (yeah I know, it's a wiki....). Anyway, it would be nice to create a page in the space that summorizes the pages that have comments on them. For now searching for type:comment is sufficient. Thanks for the quick reply!

0 votes

Hi Andre,

I believe that the application doesn't have this functionality bundled, however you could do that using some SQL query to get the pages which have comments on it. I've created this simple query to you that will show any page which have comments.

Select distinct (title) from content
where contentid in
(select pageid FROM content where contenttype = 'COMMENT');

Cheers,

Rodrigo

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 24, 2018 in Confluence

Atlassian Research opportunity with Confluence templates

Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time!   We're looking for people to participate in a   remote 1-hr workshop...

1,565 views 26 14
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you