Is there a way via Chameleon, or the API itself to get a count of the number of friends that a User has. Or will this need to be a custom Stored Procedure or SQL statement?
For a programatic method, you could try (where xxxx is the ID of the user to get the number of friends of)
CommunityServer.Components.Friendships.GetFriendships(xxxx).Count
CS Documentation - now available in downloadable PDF form
My CS Site
I have found a non-programmatic way of achieving this. By using a FriendList control and having a QueryOverrides section that links to a Pager Control the number of friends returned in the FriendList (which will depend on the QeryOverrides) can be accessed via:
[FriendListControlId].QueryOverrides.Pager.TotalRecords
Copyright© 2008 Telligent Systems Inc. All rights reserved CommunityServer.com • Telligent.com