knowledge Base -- Control of Related Articles

[mdwylde]

Hi -

We are currently on version 2.7.2 of HESK. It's working great -- we love your software.

I have a question about how to control where the related articles pull from in the knowledgebase database. It appears somewhat random. I have a problem that I have recently recreated separate printer and plotter categories and they appear to be cross-populating in the related articles read out. In the listed categories, the articles are showing both printer and plotter related help articles.

http://www.ced.berkeley.edu/cedhelp/adm ... ategory=22
http://www.ced.berkeley.edu/cedhelp/adm ... ategory=24

Is there a way to control which category the related stories are coming from? I don't see an option available in the edit view, or a way to manage it in the knowledgebase settings.

Thank you,
Marge

[Klemen]

Related articles are searched form the entire database; there is no built-in way of limiting them to the current category.

However, you can make a small modification to the "knowledgebase.php" script to achieve this: open it in a powerful text editor such as Notepad++ then just after

Code: Select all

ON t1.`catid` = t2.`id` WHERE t1.`type`='0' AND t2.`type`='0'

add

Code: Select all

 AND t1.`catid`={$article['catid']} 

That should do the trick.

[mdwylde]

Terrific --

Thank you!
Marge