AND logic versus OR logic
Simple searches use
AND logic.
Advanced searches do not have to use OR
logic. The OR logic is used when you specify multiple
criteria for extension fields, extension tables, references, or
contexts.
Each tab, like Context, Sets,
and Status, use the AND logic between the tabs. This is regardless of whether
you are using Simple or Advanced criteria for a particular tab.
Multiple selections for Simple criteria translate into the SQL operator "IN".
Example
In this example, you are combining
OR logic with
AND logic. You are searching for all formulas that
have a country of origin of China, Malaysia, or Vietnam and a status of
200,
300, or
400.
’COUNTRY_OF_ORIG’ IN ("CHINA", "MALAYSIA", "VIETNAM") AND
STATUS IN ("200", "300", "400")