And Versus Or

Revision as of 19:19, 3 May 2013 by Joe (talk | contribs)

Search definitions allow you to specify two different kinds of logical conditions. When you specify search criteria you may need all search criteria to be true in order for a record to be included in the search results. In this situation, the AND condition indicates that each and every search criteria be true for a record to be included. If any of the criteria within the AND node is false, the record will not be included in the search result. For example, the search definition shown in the image below requires that a land have a status equal to Open and a priority equal to High. In this example, both conditions must be true in order for the land to be included in the result set.

Example of a Search Using the AND Condition

Example of a Search Using the AND Condition

In other situations, an item record may only need to satisfy one search criteria to be included in the search results. When this is the case, you should use the OR search condition. The OR condition indicates that only one search criterion must be true.

Example of a Search Using the OR Condition

Example of a Search Using the OR Condition

The AND and OR conditions group the search criteria within the group together. The search conditions can be nested within one another to create more complex search criteria.