Support archive

Range search including what it should not

TJ Draper 24 Aug 2015 18:05 question, complete

Hey Low,

I’m having an issue where range search is including results it should not be including. I’m using this as a param in the query string:

range:price=200000|9999999999999999999999999999999999

I am getting results from entries where my test entry price field value is the following:

54374
99781
42138
31856
9183

Similarly, when I do:

range:price=150000|200000

I get a result where the price field value is:

15964

I have tested using parameters on the tag directly and I get the same results:

{exp:low_search:results
range:price="200000|9999999999999999999999999999999999"
}

{exp:low_search:results
range:price="150000|200000"
}

Any idea what might be causing this issue?

Replies

1. TJ Draper 24 Aug 2015 18:08

   Oh, forgot to add that I also tried with the seperate range-from and range-to options both as params and query string.

2. Low 24 Aug 2015 18:22

   The price field probably is TEXT in the DB. In the field settings, change the content type to something other than "Any".

3. TJ Draper 24 Aug 2015 18:30

   Ahhhh. Sweet sanity! Also, I feel dumb.
   
   Thanks!