Forum Discussion

nickyates's avatar
nickyates
Mentor
12 years ago

sorting forum posts by the number of messages in each post

I am trying to make a custom component which displays the 3 forum posts with the most comments.  I am having trouble displaying the posts in decending numerical order of the number of comments each p...
nickyates's avatar
nickyates
Mentor

Hi Yuri,

 

Now ive added some more activity to my board ive noticed that the ordering isnt quite right.  My top 5 boards are ordered by the number of messages as shown descibed in your code above however it is ordered as described below

 

5

3

11

1

1

 

I believe this is because the sort_by is assuming that the content of the count field is text.  In a previous thread (https://lithosphere.lithium.com/t5/developers-discussion/sorting-forum-posts-by-the-number-of-messages-in-each-post/m-p/83626#M2959) i added in the ?number command however when i do the same here it throws an error.

 

Thanks 

 

Nick

AdamN's avatar
AdamN
Khoros Oracle
12 years ago

Here's an alternate approach that may work for what you're trying to do:

http://lithosphere.lithium.com/t5/developers-discussion/How-to-filter-topics-based-on-highest-replies-across-community/m-p/82542/highlight/true#M2900

 

One downside is that you'd have to make a separate REST API call per message to get the number of replies, ie.

/messages/id/1234/replies/count

You can use the href attribute to make it easier, though. For example:

<#assign messages=rest("/search/messages?q=is_root:true&sort_by=-replies").messages />
<ul>
<#list messages.message as message>
	<#assign count = rest(message.@href + "/replies/count").value />
	<li>${message.id} - ${count}</li>
</#list>
</ul>

 I hope this helps!