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.
  • peterlu's avatar
    peterlu
    5 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

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)
5 years ago

Hi sateesh999 , 

 

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

 

Thanks!