Filtering Array Attributes in Searches

When specifying filter criteria in a search, some of the attributes in the case class may be arrays.

1. When you are filtering an array, or an item in an array, a field appears next to the array name on the Filter pane.
   The field appears for most operators, like Equal, Not Equal, Greater Than, Null, and so on (there are some exceptions that are described below). The valid entries for this field are:

   Option	Description
   ANY	Returns any of the items in the array that match the specified criteria
   ALL	Returns all of the items in the array that match the specified criteria
   An index number	Returns the cases that match the specified criteria at that index number (zero based).

2. You can use tags in filter expressions to build more complex compound expressions. Tags are used when you want to stipulate that one or more of the compound expressions are to evaluate the same members of the array, or different members of the array.

   Tags only make sense when you are building compound expressions. A tag is entered in the array field on the Filter page by entering a $ character followed by a letter (a-z), optionally followed by additional letters or integers. The tag value following the $ is arbitrary, although each tag value represents a unique member of the array.

3. When you are filtering on an array attribute, the following Size... operators are available:
   • Size Equal
   • Size Not Equal
   • Size Greater Than
   • Size Greater Than or Equal
   • Size Less Than
   • Size Less Than or Equal
   These operators allow you to specify that cases be returned that have a certain number of members in the array.