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

sateesh999's avatar
sateesh999
Contributor
5 years ago

Thank you Peterlu.

 

Regards,

Sateesh.