Page 1 of 1

The scope of AND and OR in the smart search

Posted: Thu Sep 08, 2022 3:22 am
by Dellu
I couldn't understand how the scope of OR and AND works in the Smart Search.

I want to filters books and Edited Books by a specific Author, call him Spencer. I am able to do using the Regex search:

Code: Select all

 (authors REGEX 'Spencer' OR editors REGEX 'Spencer') AND ("type" = 2 OR "type" = 6)
. It would have been easier/faster to do it with the regular smart search. I tried to emulate it like follows:
09_08_22 at 10.25.45AM.png
09_08_22 at 10.25.45AM.png (31.88 KiB) Viewed 1363 times
But, I am not getting the same result. The guide doesn't have much information on this. How does the scope of AND and OR works there?

Re: The scope of AND and OR in the smart search

Posted: Thu Sep 08, 2022 7:37 am
by Jon
The Find UI doesn't have the option to group searches, so they are executed sequentially as entered. As you see, you should use an SQL search if you want more complicated searches.

Jon
Sonny Software

Re: The scope of AND and OR in the smart search

Posted: Thu Sep 08, 2022 12:34 pm
by Dellu
OK; thanks