Search Object multiple term "AND" rather than "OR"?

[markadavies]

Hi,

As I understand it, if multiple search terms are input to a Search Box, results will be displayed for ANY matching term.

Is it possible to make the search return only where BOTH terms are found?

As an example, if I have 3 rows containing the following text ...

1 "Cheese"

2 "Onion"

3 "Cheese and Onion"

If I enter into a Search Box "Cheese Onion", I believe that I will get all 3 rows returned.

How can I enter a search where only the 3rd row "Cheese and Onion" is returned?

Many Thanks

Mark

[sunny_talwar]

See if this application is helpful.

[swuehl · Accepted solution]

Try a compound search

(*cheese* & *onion*)

See also

Compound Search - demystified

[markadavies]

Thanks swuehl, perfect!

The Compound Search - demystified link is very helpul !

[markadavies]

Thanks Sunny

Very clever, but I am particularly looking to enable multiple search terms over a number of fields - it looks like the compound search is what I am looking for

Really like your example though!