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 vote

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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Kesha Thillainayagam
Posted Apr 13, 2018 in Confluence

We want to hear how your non-technical teams are using Confluence!

Hi Community! Kesha (kay-sha) from the Confluence marketing team here! Can you share stories with us on how your non-technical (think Marketing, Sales, HR, legal, etc.) teams are using Confluen...

2,297 views 25 10
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