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
Published Mar 12, 2019 in Confluence

Confluence Admin Certification now $150 for Community Members

More and more people are building their careers with Atlassian, and we want you to be at the front of this wave! Important Dates Start the Certification Prep Course by 2 April 2019 Take your e...

1,645 views 4 13
Read article

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