Forum Discussion

sateesh999's avatar
sateesh999
Contributor
4 years ago

How to get the latest views/article in the community? Limit is 50

We are looking for an API that either provides the top 50 articles that are top trending or featured results across the community.

  • peterlu's avatar
    peterlu
    4 years ago

    SELECT id, subject, conversation.style, conversation.last_post_time_friendly FROM messages WHERE conversation.featured = true AND depth=0 ORDER BY conversation.last_post_time DESC LIMIT 50

  • peterlu's avatar
    peterlu
    Champion
    4 years ago

    SELECT id, subject, conversation.style, conversation.last_post_time_friendly FROM messages WHERE conversation.featured = true AND depth=0 ORDER BY conversation.last_post_time DESC LIMIT 50

    • TedV's avatar
      TedV
      Khoros Alumni (Retired)
      4 years ago

      Hi sateesh999 , 

       

      If you found the answer to be satisfactory, would you mind marking it as an accepted solution?

       

      Thanks!