MonoX support board

Start the conversation, ask questions and share tips and solutions with fellow developers.

Non-registered users can only browse through our support boards. Please register now if you want to post your questions. It takes a second and it is completely free. Alternatively, you can log in without registration using your credentials at major sites such as Google, Microsoft Live, OpenId, Facebook, LinkedIn or Yahoo.

Sort users by their reputation  (Mono Support )

Viewed 9840 time(s), 4 post(s) 3/4/2012 2:34:32 AMby Mony11
Mony11

Mony11

3/4/2012 2:34:32 AM
we have limited options to sort users list. We would like to show users sorted based on overall reputation or yesterday's reputation
This content has not been rated yet. 
42 Reputation 4 Total posts
khorvat

khorvat

3/4/2012 11:25:01 AM
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
This content has not been rated yet. 
15993 Reputation 2214 Total posts
Mony11

Mony11

3/4/2012 11:27:13 PM
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)
This content has not been rated yet. 
42 Reputation 4 Total posts
khorvat

khorvat

3/17/2012 12:36:05 AM
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
This content has not been rated yet. 
15993 Reputation 2214 Total posts