Sorting by number

Guest · Post by **Guest** » Tue Jun 03, 2003 12:08 am

I have a list of tests numbered 1-150, the number is the test name because our site names are numbers. Sorting will go in the following order 1,2,3,......10,111,122,2....and so on. Is there a way to fix this. I've already tried defining only one column for sorting. but it's not working.

KS-Soft · Post by **KS-Soft** » Tue Jun 03, 2003 11:58 am

>Sorting will go in the following order 1,2,3,......10,111,122,2....and so on.

Not really. Test Name field is a text field, it means HostMonitor sorts this field in alphabetical order. Like 1, 10, 11, 110, 111, ... 12, 13, ... 2, 20, 21, 22, 23, ...
If you want to see tests in 1,2,3 order, use 0 as leading character. Name tests like 001, 002, 003, ... 098, 099, 100.

Regards
Alex

<font size=-1>[ This Message was edited by: KS-Soft on 2003-06-03 11:59 ]</font>