how to find pages that have comments

[Andre van der Elst]

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 ?

[Geert Graat]

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.

[Rodrigo Girardi Adami]

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]

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!