bhupen
10 years agoAdvisor
How to show highest reply posts?
Hi guyz i want to show higest reply topic in my platform. I can show using API V1 but iam not sure about API V2 query. Following is the query I need to confirm only sql query in it. rest of code is ...
- 10 years ago
hi guys,
I got the solution and posting here to help other: I have used API V2 method to achive this. I showed only top 5 post who have most reply:
<h3>Trending Post or Post who have higest reply</h3> <br />
<#assign messages = rest("2.0","/search?q=" + "SELECT * FROM messages WHERE replies.count(*)>0 AND depth=0 order by replies.count(*) desc LIMIT 5"?url) />
<#if messages.data.items??>
<#list messages.data.items as recent >
<#if recent?has_content>
<a href="${recent.view_href}">${recent.subject}</a><br/>
</#if>
</#list>
</#if>