Query for blog posts with most likes ever

Question

There are several questions here that did not help me. I would like to find out what the most popular blog posts in our entire site are. This should be based on likes. So the output should be listing the blog posts with most likes no time limit. Additional output could be

- number of comments would be perfect 
- blog author
- Space
- blog id...

Would be great if anybody can help out here :)

Jan_g3ilhn · Answer

Hi Shannon, the Popular Tab is not really helpful in this case as it seems to refer to recent content only. In order to get the most popular blog post per month, year or even all times I cannot use this. I will check the other links you shared - thanks for this :)

Shannon S · Answer

Hi Jan,

The Popular tab will show the most heavily liked and visited pages in Confluence.

For an actual database query, I would recommend reviewing this thread, which shows you where you can actually query the likes and obtain all the details you require via the database.

You may also want to consider writing a User Macro if you need this content as a macro in Confluence.

Regards,

Shannon