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

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

  • sateesh999's avatar
    sateesh999
    Contributor
    5 years ago

    Thank you Peterlu.

     

    Regards,

    Sateesh.