known issue Numerical Sorting

[2002faq]

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 

[Marc]

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

[2002faq]

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.

 

[opentype]

I remember discussions about this years ago. I don’t know if it was ever addressed. 

[opentype]

Here is one from last year with a mention of a fix in 4.7.

 

[Marc]

I've added a bug report on this so we can further investigate

[2002faq]

@Marc Stridgen, is there a way to follow the progress on the bug report?

Thank you,

Steve 

[Marc]

We do not have a way in which to follow bug reports. It would however be updated here once its resolved

[Marc]

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