Web+Center Support
22 Oct

Knowledge Base Detail

Case Summary: How can we change the sort order for categories?
ID: 335
Date Created: 05/09/2001
Last Modified: 09/03/2001
Problem Type: Problem Report
Item: Tech+Center 3.0
Resolution:
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.

Return to FAQ List


Home | Search

Web+Center
Free and affordable Web-based Help Desk
Version: Ver. 9.0 - 02.07.17
(C) 2015 Internet Software Sciences
www.inet-sciences.com