KnowledgeBase template

Hi,
to add subcategories create new table in the database on the Datasource tables tab or using any MySQL administrative tool.

Then edit articles table and add new field - subcategory. Set up category and subcategory in the articles table as dependent dropdown box on the "Edit as" settings dialog on the Visual Editor tab.

Hi Jane,

This works only partially in that it allows to add and edit subcategories but doesn't show up in the main

menu list as a breadcrumb like the category field shows up.

I guess I have to join the new created subcategory table together with both the articles table and the Category table;

using the SQL editor and there things get really confusing for a noob like me <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=29852&image=1&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />

Hi,
to add subcategories to the menu edit SQL query of main view on the Edit SQL query tab, join subcategories table. Then add subcategories field to the page on the Visual Editor tab (using Insert field ... option).