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.
Before you go...
If you've found this post helpful, you can buy me a coffee. It's certainly not necessary but much appreciated!
Leave A Comment
If you have any questions or suggestions, feel free to leave a comment. I do get inundated with messages regarding my posts via LinkedIn and leaving a comment below is a better place to have an open discussion. Your comment will not only help others, but also myself.