Sorting Service Request Area

NIcholas_Scott

Is there any way to change the sort order of the Service Request Area? Our portal has been in production long enough that using an override will probably not work, so I'm stuck using the out of the box Service Request area list. I want to rename some list values and this will result in them being non-alphabetical when displayed in the portal.
Example:
Hardware and Peripheral Requests
Active Directory Requests
Network Requests

Can this list be sorted using a custom javascript or am I out of luck?

David_Morris1

Hi,

the list values are based on enumeration IDs so if for instance you have a value currently "hardware" and change the name to "US based Hardware" this will change all current requests in the system that have this area to the new displayname as the background item remains the same.

you can move these items up and down in the list section of the console at will to make them alphabetical or in any other order you like but to promote this change up to the portal you need to delete the lists from the portal database and let the cache builder recreate them

to do this run the following against your portal db ("Servicemanagement" by default)

DELETE DisplayString WHERE ElementID IN (SELECT EnumerationID FROM
Enumeration WHERE CreatedBy = 'c6745a66-5ccc-4fbc-b1d8-ab9797cdea2d');
DELETE Enumeration WHERE CreatedBy = 'c6745a66-5ccc-4fbc-b1d8-ab9797cdea2d';
TRUNCATE TABLE LastModified;

and then restart your cache builder service.

**Please be aware that this will rebuild all lists in the portal and can take a little while to do so, so i would suggest running it out of hours**

David_Morris1

Hi,

the list values are based on enumeration IDs so if for instance you have a value currently "hardware" and change the name to "US based Hardware" this will change all current requests in the system that have this area to the new displayname as the background item remains the same.

you can move these items up and down in the list section of the console at will to make them alphabetical or in any other order you like but to promote this change up to the portal you need to delete the lists from the portal database and let the cache builder recreate them

to do this run the following against your portal db ("Servicemanagement" by default)

DELETE DisplayString WHERE ElementID IN (SELECT EnumerationID FROM
Enumeration WHERE CreatedBy = 'c6745a66-5ccc-4fbc-b1d8-ab9797cdea2d');
DELETE Enumeration WHERE CreatedBy = 'c6745a66-5ccc-4fbc-b1d8-ab9797cdea2d';
TRUNCATE TABLE LastModified;

and then restart your cache builder service.

**Please be aware that this will rebuild all lists in the portal and can take a little while to do so, so i would suggest running it out of hours**