Display all pages of a space, ranked by Like count?

Question

Hi,

I'd like to display a list of all pages of a space, ranked by their Like count.

Is there an easy way to do that with a macro thats shipping with Confluence? Or is it reasonably easy to achieve with a user macro?

(I know that would be possible by using the page property report macro, because it has the option to display the Like count, and then one can order the table by Like count. But, most pages don't contain the page property macro, so this does not work in my case.)

Thanks!

Henning van Ackeren · Answer

Thanks Tarun!

The other thread recommends a workaround using the content report macro. However results are not sortable with that approach.

@AlL:

Before looking into buying an add-on I'd like to find out if a user macro can do the job. It'd be great if somebody could comment on that!

Tarun Sapra · Answer

Hello @Henning van Ackeren

Possible Duplicate here

https://community.atlassian.com/t5/Confluence-questions/Sort-page-search-results-by-amount-of-likes/qaq-p/819585

ANother way you can do it is by using the paid plugin

https://marketplace.atlassian.com/apps/225/sql-for-confluence-pro-edition?hosting=server&tab=overview

And query your DB and show the results in the page.