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.
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.
Categories
Support
If you've found anything on this blog useful, you can buy me a coffee. It's certainly not necessary but much appreciated!