Mono Support Sort users by their reputation 

Viewed 10499 time(s), 4 post(s), 3/4/2012 2:34:32 AM - by Mony11
3/4/2012 2:34:32 AM
42 Reputation 4 Total posts

we have limited options to sort users list. We would like to show users sorted based on overall reputation or yesterday's reputation

1
3/4/2012 11:25:01 AM
15993 Reputation 2214 Total posts

Hi,

can you please tell us to which module are you referring ? We need to know that so we can provide you with the guidance.

Regards

2
3/4/2012 11:27:13 PM
42 Reputation 4 Total posts

I would like to show the most active (top reputation) users (their name or ID and their reputation) list next to the MonoX Discussion Board. Also, at group page level, I would like to show a list of group's high reputation users (show their avatar)

3
3/17/2012 12:36:05 AM
15993 Reputation 2214 Total posts

Hi,

you should create a query (LLBLGen, LINQ etc.) that will select SUM of rating field from SnRating table and that will filter by the section you need over the SnRelationship table, by section I mean the discussion tables like SnDiscussionTopic, SnDiscussionMessage. In your case you should probably use the SnDiscussionMessage as users in forum rate the actual posts (messages) so you want to sum that rating in overall user rating for discussion.

For group reputation web part you should use the same technique but you should also include the AlbumId, SnFileId from the SnRelationship table as user can rate photo albums and photos from the group.

Let us know if you need more information.

Regards

4
This is a demo site for MonoX. Please visit Mono Software for more info.