The request was not for the client to get the data out of the database as you discussed in the tickets. The request was to mark comments as archived so they don't show in the blog.

I figured out a way to do this by setting the Blog_Comment to show in the system tables and adding a bit field named IsArchived. Then I went into the code and added this so the user could mark a comment as archived, and to exclude any comments from being viewed that have this set to true. To get around not being able to change CMS.Blogs.BlogCommentInfo, I just created a couple procs to do the get and set for IsArchived.

This will pose issues if the client decides to ever upgrade Kentico. It would be nice if a future version would allow for setting blog comments to archived so they don't show in the blog but still exist in the data.

Objects involved to accomplish this:
* CMSModules/Blogs/Controls/Blogs_Comments.ascx
* CMSModules/Blogs/Controls/BlogCommentEdit.ascx
* CMSModules/Blogs/Controls/BlogCommentView.ascx
* CMSModules/Blogs/Controls/CommentFilter.ascx
* CMSModules/Blogs/Tools/Comments_List.xml
* CMSModules/Blogs/CMSPages/Comment_Edit.aspx
* CMSWebParts/Blogs/BlogComment.ascx
* CMSResources/CMS.resx
* App_Themes/Default/CMSDesk.css