Newbie Question for All field Search

jtNew Member

Usually when I wanted retrive a group of selected items for example Countries: Singapore, Malaysia and Thailand, I need to click match 'Match One or More' in the Sub Menu. This is reasonable as I am not asking to retrive an entry with three Countries name all together.

What I am confuse about is, apply the same theory as above. If wanted to 'remove' countries from the list, in order to get the correct result, I have to select 'Must Match All' in the Sub Menu(Country List) instead of 'Match One or More'. What is the reason behind this?

Thanks for the help, I really appreaciate.

3/18/083:08 AM

❤️ 0

Original Post

Replies sorted oldest to newest

gordNew Member

I *think* this is really just a basic logic question.

A boolean expression is one that evaluates to either TRUE or FALSE. The expression

Country='Canada'

will either be TRUE or FALSE depending on what is in the "Country" field (leaving aside NULL values for the moment).

Logical negation is the process of "flipping" values between TRUE and FALSE.

NOT(TRUE) = FALSE
NOT(FALSE) = TRUE

When selecting records for multiple countries you need to OR the values together, e.g.

Country='Singapore' OR Country='Malaysia'

When negating a boolean expression you must remember that

NOT(A OR B) = NOT(A) AND NOT(B)

so therefore

NOT(Country='Singapore' OR Country='Malaysia')

is the same as

Country<>'Singapore' AND Country<>'Malaysia'

Does that help?

.

3/28/0811:39 AM

❤️ 0

jtNew Member

Im afaid your explaination seems abit too complex. I would appreciate your can use more simple example