- This topic has 1 reply, 2 voices, and was last updated 8 years, 5 months ago by
.
Viewing 2 posts - 1 through 2 (of 2 total)
Viewing 2 posts - 1 through 2 (of 2 total)
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
Trevor.
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.