Forum Discussion

sateesh999's avatar
sateesh999
Contributor
5 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.

  • 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

  • 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)

      Hi sateesh999

       

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

       

      Thanks!