filter product wrong results on minimum height

-- HikaShop version -- : 4.7.2
-- Joomla version -- : 4.2.9
-- PHP version -- : 8.1

Hi,

I created a filter on the product height. It works fine for most of the values except for the minimum height. When selecting the filter "HOOGTEMAAT FILTER" with the filteroption "below 10 cm" the results show also the products with a height of 10 cm. See screenshots for example and settings for product and filter.

Hi,

That's normal. The "below 10 cm" is actually a <=, not a < operation.

Thanks, in which file can I change this?

Hi,

I believe it is this code: in the file administrator/components/com_hikashop/classes/filter.php
The "BETWEEN" condition in MySQL is inclusive:
stackoverflow.com/questions/5080824/mysq...clause-not-inclusive
And so, for "below 10", this code actually adds the condition "BETWEEN 0.0 AND 10.0"