I’ve been using Message Boards for some page templates within my Kentico site. I needed to count the number of messages for each document to be displayed on the homepage. I couldn’t find a way to do this using Kentico’s API.
The only way I could retrieve the message count for a document is to query the database directly. The SQL query is as follows.
SELECT COUNT(*) FROM Board_Board JOIN Board_Message ON Board_board.BoardID = Board_Message.MessageBoardID WHERE Board_Message.MessageApproved = 1 AND Board_Board.BoardDocumentID = @DocumentID
If anyone knows how to achieve the exact same thing through the API, please leave a comment.