Search Terms

[kiksekage]

Starting with the "contains" option, I notice that this does not work as I would expect:

Contains: first second

It appears to be an "exact phrase" search.
But I think that this works:

Contains: first % second

Is that right? Is it possible to specify different kinds of searches - AND, OR? For example:

Contains: first AND second
Contains: first OR second

Sorry if I missed something obvious here but I just want to make sure I know how to search things. As a suggestion, it would be nice to have this as a default:

Contains: first second
(finds first AND second, in any order)
Contains "first second"
(finds first AND second, in that order)

Thank you!

[pre]
You are using DaDaBIK version 8.1-Lerici enterprise
PHP Version: 7.0.24
mysql version: 5.6.37
Web server: Apache
Client: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/52.0 .2743.116 Safari/537.36 Edge/15.15063
[/pre]

 

[eugenio]

Hello,
the "contains" operator works following this pattern:

LIKE '%first second%'

so yes, it is different respect to '%first%second'.

You can use boolean operators AND / OR with search textboxes, for an example see demo n.2 -> products -> search.

Best,