our projects are numbered: 53, 82, 87, 100, 191, 204 etc
when I sort the projects by ‘Name’ it sorts them as follows:
100
191
204
53
82
87
Any chance you can tweak the code so that they are sorted in numerical order?
53
82
87
100
191
204
Projects not sorting properly
 |
|
|
|
found a work around which is to change the project numbers to: 053, 082, 087 (easy since they are short numbers) but Solve should still sort properly in case people have longer project numbers |
 |
The field is text, not numeric. You might find some humor in this post about Natural Sort Order… |
|
|
OK, thanks for the info. Good stuff! Not being a coder (probably like many of your users), it’s easy to find little issues that ‘appear’ simple to fix but in reality aren’t. I put some zeroes in front (and a # as to help with the linked emails since with just a project number like 100 it was pulling all sorts of things). Thanks! |
|
|
Yeah, the issue is computer software (e.g. databases etc) don’t support “natural sorting” algorithms. We did develop a solution internally, but we’re concerned that the extra processing will increase response time to key areas. We’re keeping an eye on it though. |