This thread is resolved. Here is a description of the problem and solution.
Problem: I have a View that is filtered by a custom field value, set by a URL parameter. The results should include posts that have a custom field value less than or equal to the number I pass into the URL parameter. The results do not seem to be accurate, because param=999 gives me 3 results but param=1000 gives me no results.
Solution: Check the query filter settings. The compare value type should be "UNSIGNED" instead of "string" when comparing numeric values.
Relevant Documentation:
https://toolset.com/documentation/user-guides/filtering-views-by-custom-fields/#compare-value-type
This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.
Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.
No supporters are available to work today on Toolset forum. Feel free to create tickets and we will handle it as soon as we are online. Thank you for your understanding.
| Sun | Mon | Tue | Wed | Thu | Fri | Sat |
|---|---|---|---|---|---|---|
| 8:00 – 12:00 | 8:00 – 12:00 | 8:00 – 12:00 | 8:00 – 12:00 | 8:00 – 12:00 | - | - |
| 13:00 – 17:00 | 13:00 – 17:00 | 13:00 – 17:00 | 13:00 – 17:00 | 13:00 – 17:00 | - | - |
Supporter timezone: America/New_York (GMT-04:00)
This topic contains 2 replies, has 2 voices.
Last updated by 6 years, 7 months ago.
Assisted by: Christian Cox.
I am trying to: display woocommerece products based on a view that get urlparm (query string) of price and display max 5 products with price equal or less than the price defined in the urlparm
Link to a page where the issue can be seen: hidden link
I expected to see: no products listed on the page
Instead, I got: 3 products with price higher than 999 display on the page
i noticed that there is a range of price this is happen
for example"hidden link
will get no results as expected.
however if i change urlparm to 20 like this
hidden link
i will get one result
if i use hidden link
i get three results
if i use hidden link
i get no results as expected
i have only 5 products in the store with variations of max 2 variations to each of four products and one product with no variations.
you can see the view search setting in the enclosed image
Please advice,
thanks,
David
