[Skip to main content](#vessel-content)

#   filter product wrong results on minimum height

##

- **[jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile")**
- [![jouwnaambord.nl's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile") Topic Author
- [ Offline](/forum/user/1188-jouwnaambord-nl)

Less More

- Posts: 515
- Thank you received: 22
-
-

3 years 7 months ago [\#351123](#351123) by [jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile")  *[filter product wrong results on minimum height](/forum/45-filters-search/906285-filter-product-wrong-results-on-minimum-height#351123 "-- 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 &quot;HOOGTEMAAT FILTER&quot; with the filteroption &quot;below 10 cm&quot; the results show also the products with a height of 10 cm. See screenshots for example and settings for product and filter.")* was created by *[jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile")*

-- 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.

- [ ![hika-height-filter.jpg](/forum/attachment/56933) ](/forum/attachment/56933 "...ght-filter.jpg") [ ](/forum/attachment/56933?download=1 "...ght-filter.jpg")
- [ ![product-measures.jpg](/forum/attachment/56934) ](/forum/attachment/56934 "...t-measures.jpg") [ ](/forum/attachment/56934?download=1 "...t-measures.jpg")
- [ ![filter-page.jpg](/forum/attachment/56935) ](/forum/attachment/56935 "filter-page.jpg") [ ](/forum/attachment/56935?download=1 "filter-page.jpg")

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwNjI4NS1maWx0ZXItcHJvZHVjdC13cm9uZy1yZXN1bHRzLW9uLW1pbmltdW0taGVpZ2h0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

3 years 7 months ago [\#351126](#351126) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[filter product wrong results on minimum height](/forum/45-filters-search/906285-filter-product-wrong-results-on-minimum-height#351126 "-- 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 &quot;HOOGTEMAAT FILTER&quot; with the filteroption &quot;below 10 cm&quot; 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 &lt;=, not a &lt; operation.

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwNjI4NS1maWx0ZXItcHJvZHVjdC13cm9uZy1yZXN1bHRzLW9uLW1pbmltdW0taGVpZ2h0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile")**
- [![jouwnaambord.nl's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile") Topic Author
- [ Offline](/forum/user/1188-jouwnaambord-nl)

Less More

- Posts: 515
- Thank you received: 22
-
-

3 years 7 months ago [\#351166](#351166) by [jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile")  Replied by *[jouwnaambord.nl](/forum/user/1188-jouwnaambord-nl "View jouwnaambord.nl's Profile")* on topic *[filter product wrong results on minimum height](/forum/45-filters-search/906285-filter-product-wrong-results-on-minimum-height#351166 "-- 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 &quot;HOOGTEMAAT FILTER&quot; with the filteroption &quot;below 10 cm&quot; the results show also the products with a height of 10 cm. See screenshots for example and settings for product and filter.")*

Thanks, in which file can I change this?

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwNjI4NS1maWx0ZXItcHJvZHVjdC13cm9uZy1yZXN1bHRzLW9uLW1pbmltdW0taGVpZ2h0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

- **[nicolas](/forum/user/63-nicolas "View nicolas's Profile")**
- [![nicolas's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar63.png?1793428657)](/forum/user/63-nicolas "View nicolas's Profile")
- [ Offline](/forum/user/63-nicolas)

Less More

- Posts: 86576
- Thank you received: 14320
-
-

3 years 7 months ago [\#351173](#351173) by [nicolas](/forum/user/63-nicolas "View nicolas's Profile")  Replied by *[nicolas](/forum/user/63-nicolas "View nicolas's Profile")* on topic *[filter product wrong results on minimum height](/forum/45-filters-search/906285-filter-product-wrong-results-on-minimum-height#351173 "-- 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 &quot;HOOGTEMAAT FILTER&quot; with the filteroption &quot;below 10 cm&quot; the results show also the products with a height of 10 cm. See screenshots for example and settings for product and filter.")*

Hi,

I believe it is this code: Code:

$limit=' ( '.$column.' ) BETWEEN '.(float)$values[0].' AND '.(float)$values[1].' ';

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](https://stackoverflow.com/questions/5080824/mysql-between-clause-not-inclusive)
And so, for "below 10", this code actually adds the condition "BETWEEN 0.0 AND 10.0"

Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzQ1LWZpbHRlcnMtc2VhcmNoLzkwNjI4NS1maWx0ZXItcHJvZHVjdC13cm9uZy1yZXN1bHRzLW9uLW1pbmltdW0taGVpZ2h0P3RtcGw9bWFya2Rvd24=) or [Create an account](/component/users/registration?Itemid=101) to join the conversation.

Board Categories HikaShop Install &amp; Update Product &amp; Category Display Content Creation Sales and Orders Orders management Reports &amp; Statistics Customers Checkout Payment Methods Shipping Methods Import &amp; Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel &amp; Slider Mass Actions Filters &amp; Search Discount &amp; Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to?

[](/forum/topics/feed/mode-topics?format=feed&type=rss)

Time to create page: 0.048 seconds

[Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)
