ListIt sort breaks at 10,000

[kkreitz]

I have a rental property website that sorts properties by rent. Highest first to lowest last. All worked as it should until a property with the rent amount greater than 10,000 was placed down in the mix when it should have been at the top. I am assuming there is somewhere within the module that sets the number of digits for sorting, if this is the case can someone point me in the right direction? If not, any help would be appreciated.


Cms Version:1.12.1
ListIt2: 1.4.1

[chandra]

Have you set a parameter pagelimit?

If no pls try to set this value like you want.

By the way ... heared it sometimes ago from module developer - ListIt wasn't really coded to manage such a mass of data.

[kkreitz]

Thanks Chandra, I see that I was not clear. The sort does not work when the rent exceeds $10,000, not 10,000 properties.

[chandra]

Sorry, need glasses .

How do you input the rent? "$10,000" or "$10000"?

If first one sorting will fail.

[kkreitz]

It is entered in it's box on the item as 10,000. I will export the csv and remove all ,'s to see if that clears this up.

[calguy1000]

The content of all fields in LISE is a string, and therefore LISE does alphanumeric sorting, not integer sorting.

so '1' < '9' and '10' < '9' and '10000' < '9'

[kkreitz]

Thank you, if this is the case then it seems that I could create a sort field that will not be published and put a 0 in front of all rent that ranges between 999 and 10,000, since in that area there will be nothing below $1,000.