When performing a Find window search Cumulus performs one search condition after the other. The Boolean and and or operators define how Cumulus has to connect the previous and next search conditions. The operator and defines that the records must match both conditions. The operator or defines that the records need to match one of the conditions only. If you have more than two search conditions in a search query, a condition connected with and will search the matches of the previous condition and reduce this result – whereas a condition combined with or will search the entire ’search area’ (as defined under Search Method) and add the new matches to the previous matches.

First, Cumulus will search for all records that are assigned to the category Photographs and then, second, the result will be refined by searching for records that contain penguin in their names. Third, this result will be refined by searching for records that contain balloon in their names.

In the Sample Catalog the final result of this search query is:

First Cumulus will search for all records that are assigned to the category Photographs and then, second, the result will be refined by searching for records that contain penguin in their names. Third, the ’search area’ (as defined under Search Method) will be searched for records that contain balloon in their names and the matches will be added to the results of the previous conditions.