2002faq Posted March 5, 2023 Share Posted March 5, 2023 We have a database where the Title of each entry is a number. It is indicated so in the database field, but the sorting of the database fields is still alphabetical. How can the sorting be forced to be numerical? https://www.bmw2002faq.com/registry/ Thank you, Steve Link to comment Share on other sites More sharing options...
Marc Stridgen Posted March 6, 2023 Share Posted March 6, 2023 You would need to ensure you are sorting by that specific field in the settings of that database, which you can see on the options tab Link to comment Share on other sites More sharing options...
2002faq Posted March 6, 2023 Author Share Posted March 6, 2023 It is set to be sorted by that field. That field is set to be a Number Sorting is still alphabetical. Page 1 Second to the last page where you can see this: 971104 should be the first listing, but it follows 5318903 Steve K. Link to comment Share on other sites More sharing options...
opentype Posted March 6, 2023 Share Posted March 6, 2023 I remember discussions about this years ago. I don’t know if it was ever addressed. Link to comment Share on other sites More sharing options...
opentype Posted March 6, 2023 Share Posted March 6, 2023 Here is one from last year with a mention of a fix in 4.7. Link to comment Share on other sites More sharing options...
Marc Stridgen Posted March 7, 2023 Share Posted March 7, 2023 I've added a bug report on this so we can further investigate Link to comment Share on other sites More sharing options...
2002faq Posted March 15, 2023 Author Share Posted March 15, 2023 @Marc Stridgen, is there a way to follow the progress on the bug report? Thank you, Steve Link to comment Share on other sites More sharing options...
Marc Stridgen Posted March 15, 2023 Share Posted March 15, 2023 We do not have a way in which to follow bug reports. It would however be updated here once its resolved Link to comment Share on other sites More sharing options...
Marc Stridgen Posted March 17, 2023 Share Posted March 17, 2023 We have been having problems replicating this on a stock installation, so Ive created a ticket for you on this, so we can look into it further Link to comment Share on other sites More sharing options...
Recommended Posts