Low Search range not working when value is four digits
We're working on a project for a client where we list holiday homes. We are allowing the user to filter by budget, eg maximum price, 500.
I have a hidden field setting the range-from to 0, and the range-to is set by the user. I am coming across a problem where if an entry has a value that is 1000 or more, it's always displayed. If I set the entry value to 999 and then search for a maximum of 500, it doesn't show, when I set the value to 1000, it displays.
Access to the site/templates can be provided if necessary.
Replies
Low 13 Jan 2015 12:29
That's probably because the field that contains the price is a varchar field in the database, instead of a decimal/integer/float field.
Make sure the Field Content option in your field settings is set to number, integer or decimal (not "All").