www.hkvforums.com

Currently all extended search field options are bound together by AND, while normal text search fields options change between AND and OR depending on "All keywords / Any keywords" option in the quick search button.

This is a feature from a programmer's point of view. But from a user's point of view he does not know difference between quick search and extended search. He only sees several fields that he is searching, and find that All/Any keywords don't work for some fields.

For example when I do a search with two boolean fields along with text using Any Keyword settings the filter string is:

"((`payment_received` <> '1') AND (`booking_confirmed` <> '1')) AND ((`EV__course_id` LIKE '%pein%') OR (`EV__priceplan_id` LIKE '%pein%') OR (`EV__user_id` LIKE '%pein%') OR (`special_requests` LIKE '%pein%') OR (`payment_received` LIKE '%pein%') OR (`booking_confirmed` LIKE '%pein%'))"

Only the boolean fields are fixed with AND. The user gets confused and cannot understand why.

The request is to make extended search fields also change between AND and OR depending on All/Any Keywords setting.

+1

+1 very much needed

+1

Try Tools -> Advanced Settings -> Search option in v2022.