Forum Discussion

Suchith's avatar
Suchith
Ace
6 years ago

API call for Top Most viewed and Most Helpful

Hi,  I want to retrieve Most viewed and Most Helpful data from the posts for that each category category and board level.  Below V2 API will help to get most viewed message across all blogs. S...
  • VikasB's avatar
    VikasB
    6 years ago

    Suchith 
    You can put the board.id constraint in API like this

    select * from messages where board.id = 'BoardId' order by metrics.views DESC limit 3

    And I think helpfulness may relate to the popularity of the topic as I did not see anything else in message response which is closer to this

    select * from messages where board.id = 'BoardID' order by popularity DESC limit 3

     

Suchith's avatar
Suchith
Ace

VikasB 

Thanks, what should be the constraint if we are planning to get top 3 view across community.


VikasB's avatar
VikasB
Boss
6 years ago

For overall community, you can keep it defualt without any constraint. 

For  community

SELECT * FROM messages ORDER BY metrics.views DESC limit 3

For Category 

SELECT * FROM messages where category.id = 'CategoryId" ORDER BY metrics.views DESC limit 3

 For multiple boards

SELECT * FROM messages where board.id in ('boardId1','boardId2') ORDER BY metrics.views DESC limit 3