Extended Search options AND/OR

Post Reply
SRanade
User
Posts: 95

Extended Search options AND/OR

Post by SRanade »

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.


mobhar
User
Posts: 11727

Post by mobhar »

+1


Neelima
User
Posts: 35

Post by Neelima »

+1 very much needed


vintoICT
User
Posts: 407

Post by vintoICT »

+1


Webmaster
User
Posts: 9427

Post by Webmaster »

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


Post Reply