Count Message board Messages for a Document in Kentico

Published on
1 min read

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.

FROM Board_Board
JOIN Board_Message ON Board_board.BoardID = Board_Message.MessageBoardID
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!

Buy Me A Coffee

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.