Sort Order of Knowledgebase Categories and Subcategories

gsownsby · Post by **gsownsby** » Mon Feb 23, 2009 9:32 am

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.

Post by **Klemen** » Tue Feb 24, 2009 12:47 pm

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.

gsownsby · Post by **gsownsby** » Tue Feb 24, 2009 1:24 pm

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.

Post by **Klemen** » Tue Feb 24, 2009 5:09 pm

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).

gsownsby · Post by **gsownsby** » Tue Feb 24, 2009 6:34 pm

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.

fk59 · Post by **fk59** » Thu Jan 21, 2010 7:32 am

Hi there,

is this now possible without editing database?

Would be great!

Frank

Post by **Klemen** » Thu Jan 21, 2010 4:24 pm

Not possible yet, but should be in the future.