And and Or (SelectionCriterion functions)

Create selection expression based on logical operator (SelectionCriterion class)

These shared methods each create a new SelectionCriterion object that is an expression used to select the items in a collection. Each function uses a different logical operator to form an expression that combines one or more SelectionCriterion objects.

An Or criterion returns true for a collection item if any of the component SelectionCriterion expressions are true for the item; otherwise it returns false. An And criterion returns true if all of the component SelectionCriterion expressions are true for the item; otherwise it returns false.

The collection searching method that makes use of a SelectionCriterion specifies:

• Whether to return the first item or item number or all items that satisfy the selection criterion.
• Where in the collection to begin searching.

Syntax

%selectionCriterion = [%(SelectionCriterion For itemType):]And( list)

%selectionCriterion = [%(SelectionCriterion For itemType):]Or( list)

Syntax terms

%selectionCriterion	A SelectionCriterion object variable to contain the new object instance.
[%(SelectionCriterion For itemType)]	For a shared function, this optional specification of the class in parentheses denotes a virtual constructor. See "Usage notes", below, for more information about invoking a SelectionCriterion virtual constructor.
list	A comma-separated list of one or more SelectionCriterion objects.

Usage notes

• As described in "Virtual Constructor methods", And and Or can be invoked with no method object, with an explicit class specification, or with an object variable of the class, even if that object is Null:

  %selCrit = And(list) %selCrit = %(SelectionCriterion for float):Or(list) %selCrit = %selCrit:And(list)

  Note: As shown in the second of these above, if you explicitly specify the class name, you must include the item datatype of the collection to be searched, just as on a SelectionCriterion object variable's declaration.

• All Or and And SelectionCriterion conditions are short-circuiting conditions. That is, if any of the conditions in an Or return True, the subsequent conditions are not evaluated and the Or returns True. Similarly, if any of the conditions in an And return False, the subsequent conditions are not evaluated, and the And returns a False. Therefore, it is wise to put the most likely conditions first in an Or, and it is wise to put the least likely first in an And. For a mix of conditions where some are simply variable references and others require method evaluation, it probably is best to put the variable references first, as these are probably much cheaper to evaluate.

Examples

1. The following criterion matches numbers less than 70 and greater than or equal to 95:

   %sel = OR(lt(this,70), ge(this,95))

2. The following criterion matches numbers that are less than or equal to 33 but not 30:

   %sel = AND(le(this, 33), ne(this,30)))

See also

SelectionCriterion class	List of SelectionCriterion methods	SelectionCriterion methods syntax
Notation conventions for methods