Forums › Forums › Search & Filter Pro › Using (or) instead of (and) does not reset other value

Tagged: 

Viewing 2 posts - 1 through 2 (of 2 total)
  • Anonymous
    (Private)  October 10, 2017 at 11:32 pm #135822

    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

    Trevor
    (Private)  October 11, 2017 at 2:12 pm #135903

    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.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)