how to find pages that have comments

Question

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 ?

Rodrigo Girardi Adami · Answer

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

Andre van der Elst · Answer

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!

Geert_Graat · Answer

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.