Get Comment Count in SharePoint

Hi Guys,

In this blog I will explain how we can get the number of comments on any page/article. Prerequisites for this blog are: a list with rating enabled, an article/page/splistItem already have got comments from users and a tool like VS to code ;)

According to requirement it may be the case that one need to get item comment count using java script or c#. I will explain both way to get the comment count:

Using Javascript: This may be the case when one want to use the content search webpart or CQWP to display comment count. Followng code can be use to get the comment Count:

var linkURL = $getItemValue(ctx, "Link URL");
linkURL.overrideValueRenderer($urlHtmlEncode);

// Get the Comments count
var soapEnv =
"<soap:Envelope xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance' xmlns:xsd='http://www.w3.org/2001/XMLSchema' xmlns:soap='http://schemas.xmlsoap.org/soap/envelope/'> \
<soap:Body>    \
<CountCommentsOnUrl xmlns='http://microsoft.com/webservices/SharePointPortalServer/SocialDataService'> \
<url>" + linkURL + "</url> \
</CountCommentsOnUrl> \
</soap:Body> \
</soap:Envelope>";

$.ajax({
pageurl: linkURL,
url: "/_vti_bin/SocialDataService.asmx?op=CountCommentsOnUrl",
type: "POST",
dataType: "xml",
data: soapEnv,
contentType: "text/xml; charset=\"utf-8\"",
success: function(data, status, xhr){
if(data !== undefined) {
var commentCount = $('CountCommentsOnUrlResponse', data).find('CountCommentsOnUrlResult').text();
if(commentCount>0){
$('#'+ commentId +  ' .comments').html(commentCount);
$('#'+ commentId).show();
}
else{
$('#'+ commentId).hide();
}
}
}
});

Using server code: You must have to know the full path of the page. That is again a challenge. In most of the cases you must be having SPListItem object. Following code can be used to get the path:

var pageUrl = item["EncodedAbsUrl"] + item["FileRef"].ToString().Substring(item["FileRef"].ToString().IndexOf("#") + 1);

var context =SPServiceContext.Current;
var scManager =newSocialCommentManager(context);
var pageUri =newUri(pageUrl);
int count = scManager.GetCount(pageUri).ToString(CultureInfo.InvariantCulture);

Hope above code helped you. Kindly comment and share your views.

Happy SharePointing :)