Can I see in the statistics which post received the most likes

Product Support

AI-generated summary

Lena asked if it’s possible to see which posts received the most likes in the statistics overview. dax provided two methods to achieve this: an easy way by using the URL parameters ?order=likes or ?order=op_likes, and a hard way by using the Data Explorer plugin.

However, smrtey reported an issue with the search method, which codinghorror clarified was due to the search query returning posts the user has liked, not their most liked posts.

smrtey also raised a concern about a post with 22 likes not appearing in the search results, which Stephen explained was due to incorrect search syntax.

Finally, Bathinda asked if it’s possible to find a list of posts made by a specific user that have been liked by at least one other member.

1

Hi,

We are currently setting up our own discourse forum and I would like to know whether there is a way to see which posts received the most likes. I looked for such feature in the statistics overview but couldn’t find anything. Then again, I might have not looked properly as I am still only getting used to all these features. Thanks for your help!

2

Easy way:

discourse.example.com/?order=likes (likes gives in all topics)
discourse.example.com/?order=op_likes (likes gives in OP topic aka first post of each topic)
or discourse.example.com/search type in:likes and order results by “most liked”

likes.png691×495 26.3 KB

Hard way:
write a query for this and use Data Explorer plugin

4

This doesn’t seem to work properly. If I go to my user page here, this is a list of my most liked posts:

image
image451×359 5.18 KB

If I use search to find my most liked posts, my four most liked posts don’t appear

image
image810×508 25 KB

5

You cannot like your own post so your search query makes no sense..

6

Ok, so if that query is a list of posts I’ve liked and not my most liked posts, why does it return any of my posts? And what about this search from our forum. If I search for most liked posts I get

image
image932×726 48.4 KB

I don’t understand why this post isn’t on the list. 22 likes is more than 21.

image
image575×120 2.61 KB

7

You aren’t using the correct search syntax.

In the post from @dax the search term offered is in:likes whereas in your screenshots you’re adding a space and searching for in: likes - you’re adding a space between the operator and argument.

Spot the difference:

space
space2290×1576 493 KB
nospace
nospace2312×1772 552 KB

Look at the right hand side - when used correctly in:likes searches for posts you have liked. It automatically checks that box. When you add the space you’re actually searching for posts which contain the word likes:

likes
likes2286×1724 541 KB

Presumably the post with 22 likes doesn’t include the word likes, so wouldn’t be returned by the search query.

Edit: Confirmed, I just found the topic in question on unstuckpolitics.com. It won’t be returned for a query which it doesn’t match.

8

Is there a way to find list of all the posts made by an ‘example’ user, which has/have been liked by at least one other member?