Portal Engine Questions on portal engine and web parts.
Version 6.x > Portal Engine > Showing recent posts on blog's front page View modes: 
User avatar
Member
Member
bdrenner-new42 - 8/12/2013 11:59:17 AM
   
Showing recent posts on blog's front page
I'm trying to build a blog on an existing site by looking at the dummy Corporate Site. The Corporate Site has a "Blog posts repeater" with properties containing SQL like:

('{%ToInt(tagid, "")%}' = 0 AND '{%tagname%}'='') OR (DocumentID IN (SELECT DocumentID FROM CMS_DocumentTag WHERE TagID = {%ToInt(tagid, "")%} )) OR (DocumentID IN (SELECT DocumentID FROM CMS_DocumentTag WHERE TagID IN (SELECT TagID FROM CMS_Tag WHERE TagName = '{%tagname%}' AND TagGroupID = {%ToInt(groupid, "")%} )))

Am I correct in thinking that I need to memorize Kentico's SQL table structure in order to make a simple blog? Someone please tell me that there's an easier way of doing this.

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 8/14/2013 2:00:06 AM
   
RE:Showing recent posts on blog's front page
Hello,

No, this is not necessary. This WHERE condition is just to demonstrate using the tags on blogs and then filter the posts based on their tags. The general usage of the tags and tag cloud web part is described here. So, it has nothing to do with the actual blogs, it is additional functionality.

Best regards,
Juraj Ondrus

User avatar
Member
Member
bdrenner-new42 - 8/14/2013 9:57:51 AM
   
RE:Showing recent posts on blog's front page
Okay, thanks.