How to get topics from certain rooms?

Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more

AI OnAI Off

Home / Forums / Legacy forums / Episerver Community /

Helena Callert

Vote:

Hi,

I would like to list recent topics from several (but not all) rooms. I'm using a TopicQuery so TopicQuery.Room seems like a good start, but I can't figure out how to add more than one room ID to the query?

Best regards,
Helena

#27614

Feb 04, 2009 13:36

tost

Vote:

Hi Helena,

Something like this should work:

TopicQuery q = new TopicQuery();
q.Room = new RoomCriterion();
q.Room.ID = new IntegerCriterion();
q.Room.ID.Includes = new IntegerInCriterion();

// Inlcude rooms with id 1, 7 and 23
q.Room.ID.Includes.Values.Add(1);
q.Room.ID.Includes.Values.Add(7);
q.Room.ID.Includes.Values.Add(23);

MessageCollection topics = 
QueryHandler.GetQueryResult<EPiServer.Community.Forum.Message, MessageCollection>(q, 1, 10, out itemCount);

Best Regards,
Tom

#27667

Edited, Feb 05, 2009 15:21

Vote:

There is also the built in ForumHandler.GetTopics method that takes a RoomCollection as an argument. It will be quicker and you can use the specialised sort orders.

http://sdk.episerver.com/community/html/M_EPiServer_Community_Forum_ForumHandler_GetTopics.htm

/Mattias

#27672

Feb 05, 2009 16:27

tost

Vote:

Nice one Mattias, didn't think of that

#27674

Feb 05, 2009 16:30

Helena Callert

Vote:

Thanks a lot for your quick answers!

I think I need to use the query (?) since I want to filter on other properties as well, such as creation dates and number of topic replies.

#27676

Feb 05, 2009 16:42

tost

Vote:

Yep, that's correct. If you want to do more filtering you need to use the query system.

Best regards,
Tom

#27692

Feb 06, 2009 9:19

This thread is locked and should be used for reference only. Please use the Legacy add-ons forum to open new discussions.