November Happy Hour will be moved to Thursday December 5th.

List recent posts or topics in forum

Vote:
 

Hi

We want to list the latest posts in all rooms. The list should include both new topics and new replies then we filter out i.e the first 5 of that collection.

Can this be done using GetQueryResult? or do we have to first get all rooms and then loop through each topic?

/Halvar 

 

#32809
Sep 18, 2009 10:48
Vote:
 

I think you would have to run two queries, one TopicQuery getting the 5 last topics and one ReplyQuery getting the 5 last replies and merge the results, keeping the 5 last in total.

#32902
Sep 23, 2009 14:13
Vote:
 

Another way of doing it is to set ChangeDate when you create a new Topic and then use that to sort your query. That way you will only need one query.

#35057
Nov 26, 2009 11:19
This thread is locked and should be used for reference only. Please use the Legacy add-ons forum to open new discussions.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.