- This topic has 1 reply, 2 voices, and was last updated 7 years ago by .
These forums are now closed and remain for historical purposes.
None of the content applies to the new version 3. For support, get in touch via our contact form.
Forums › Forums › Search & Filter Pro › Using (or) instead of (and) does not reset other value
Tagged: and/or
Hi there,
When filtering via multiple selects, (and) works fine – but (or) does not, selecting the other drop-down and selecting a new value it is not resetting the original chosen. Am I not understanding the (or) condition correctly in this case?
Thanks
Q. Am I not understanding the (or) condition correctly in this case?
A. Indeed you are misunderstanding it. The use of AND and OR refer to the type of Boolean expression used in the SQL query used to extract the results. In general terms, an OR expression will increase the number of results, and an AND expression will reduce the number of results. If you have two fields then, and in the first select a term and get, say, 10 results, and then in the second field you select another term, which on its own would have five results, the OR query will be you a minimum of 10 and a maximum of 15 results. An AND query would give you between zero and 5 results.
This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.
We also use cookies to store items in your cart as well as allowing your to login on the site.
You can adjust all of your cookie settings by navigating the tabs on the left hand side.
By continuing to use this site, you also agree to our Privacy Policy.
Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.
*Other cookies used for logging in and cart functions will only be used when you use those features and cannot be disabled.
If you disable these cookie, we will not be able to save your preferences. This means that every time you visit this website you will need to enable or disable cookies again.
This website uses Google Analytics to collect anonymous information such as the number of visitors to the site, and the most popular pages.
Keeping this cookie enabled helps us to improve our website.
Please enable Strictly Necessary Cookies first so that we can save your preferences!
More information about our Cookie Policy