Page 1 of 1

Sort Order of Knowledgebase Categories and Subcategories

Posted: Mon Feb 23, 2009 9:32 am
by gsownsby
Script URL: Intranet Usage - Not Accessible from Internet
Version of script: 2.0
Hosting company: On-Site Web Server (Abyss/PHP/MySQL)
URL of phpinfo.php: Intranet Usage - Not Accessible from Internet
URL of session_test.php: Intranet Usage - Not Accessible from Internet
What terms did you try when SEARCHING for a solution: sort

After only one day of use, I must say this script is impressive in terms of its functionality, simplicity of use, speed, and visual appearance. Great job.

Certainly everyone has a wish list of enhancements but I was wondering is their a "quick" enhancement that would permit the Knowledgebase categories and subcategories to be sorted alphabetically? This would present them in a bit more logical order than by which one was created first.

My thinking would be that same level categories would sort alphabetically. Subcategories under a specific higher level category would also sort alphabetically.

Example:

Domestic Animals
--Cats
--Dogs
--Horses
Wild Animals
--Bears
--Lions

I think this would help locate categories/subcategories as the number of categories grows and becomes more complex.

Thank you.

Posted: Tue Feb 24, 2009 12:47 pm
by Klemen
Subcategories aren't supported by Hesk at the moment.

Categories won't automatically order by name as well, but you can order them in any way you wish manually by clicking the up and down arrows next to categories in the Admin panel > Categories.

Posted: Tue Feb 24, 2009 1:24 pm
by gsownsby
Oops...I think I was unclear about this.

I meant sorting for knowledgebase categories. See this image for an example of how visually messy it can get without sorting:

http://www.smokyshare.com/helpdeskkb-sort.jpg

Peer level categories don't sort. Neither do sub-categories. So order of creation seems to determine listing order.

Posted: Tue Feb 24, 2009 5:09 pm
by Klemen
Ah, it's clear now. I will add a way to order KB (sub)categories in the future version.

The database is already set to support this so if you want you can do it manually by editing the database entries - the "cat_order" table column can be used to order subcategories within categories (the higher the number the lower the category will show).

Posted: Tue Feb 24, 2009 6:34 pm
by gsownsby
Not sure I totally understand how or where to do this...

I used PHPMyAdmin to view database and sort the cat_order table entries so they look to be in order in the database but when viewed via helpdesk, not thing has changed.

I'm sure I don't know what I'm doing! Thanks.

Posted: Thu Jan 21, 2010 7:32 am
by fk59
Hi there,

is this now possible without editing database?

Would be great!

Frank :-)

Posted: Thu Jan 21, 2010 4:24 pm
by Klemen
Not possible yet, but should be in the future.