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
Rating history (Content is rated 0.00 of 0 vote(s).)
Shows who have rated the content, and the rating score.