|Case Summary: How can we change the sort order for categories?
|Date Created: ||05/09/2001|
|Last Modified: ||09/03/2001|
|Problem Type: ||Problem Report|
|Item: ||Tech+Center 3.0|
The sort order for categories is based on the category number and is not set up to be alphabetically sorted. To change the sort order to alphabetical for the category drop down lists, one will need to edit the SQL statement that is used to obtain the categories lists from the database in the techcenter and customercenter. In the Techcenter TcaseForm.asp module around 901, there is the line:
mySQL2="select * from Categories where State <> 0 Order by Category_Number, item_number"
To order by Category, change the express to:
mySQL2="select * from Categories where State <> 0 Order by Category_Number, item_name".
There is a similar SQL statement in the CustomerOptions.asp module in the customer+center directory that can be modified as well. It is around line 492.