Forum Discussion

ronaksomani's avatar
ronaksomani
Mentor
10 years ago

How to show highest Kudos posts using API2?

Hi, I want to show most active posts based on either number of kudos or views. I found a way to implement based on number of replies. But could not find similar approach for kudos/views.  For repli...
  • VarunGrazitti's avatar
    VarunGrazitti
    10 years ago

    ronaksomani - You can do it either way,

     

    Based on the number of Kudos:

    SELECT * FROM messages WHERE kudos.sum(weight)>0 AND depth = 0 ORDER BY kudos.sum(weight) DESC

Based on the number of views:

    SELECT * FROM messages WHERE depth = 0 ORDER BY metrics.views DESC

     

VarunGrazitti's avatar
VarunGrazitti
Boss
10 years ago

ronaksomani - You can do it either way,

 

Based on the number of Kudos:

SELECT * FROM messages WHERE kudos.sum(weight)>0 AND depth = 0 ORDER BY kudos.sum(weight) DESC

Based on the number of views:

SELECT * FROM messages WHERE depth = 0 ORDER BY metrics.views DESC

 

  • ronaksomani's avatar
    ronaksomani
    Mentor
    10 years ago

    VarunGrazitti Thank you for the response.

    Is there any way I can retrieve most active post based on combination of (replies / kudos / views)?

    • VarunGrazitti's avatar
      VarunGrazitti
      Boss
      10 years ago

      ronaksomani  - Yes, you can do that, you can sort them based upon any one factor, either views, kudos or replies. In the following query, I've sorted it by views and included the kudos and replies as well.

       

      SELECT * FROM messages WHERE kudos.sum(weight)>0 AND replies.count(*) > 0 AND depth = 0 ORDER BY metrics.views DESC

       

      I hope this helps.

      • ronaksomani's avatar
        ronaksomani
        Mentor
        10 years ago

        VarunGrazitti  Above query will filter posts having kudos and replies greater than 0, and will order them  by views count. But I am looking for a query (if possible), where I can ORDER BY combination of (replies/kudos/views). Thus I will get a response which will have most active posts.