Filtering Data

You can apply selection criteria to database fields to filter data in the collection (for example, retail sales with a price greater than $10,000).

The selection operator for each database field can be one of the following.

• Null

• Equal to

• Greater than

• Greater than or equal to

• Less than

• Less than or equal to

• One of

• Between

• Starts with (string fields)

• Ends with (string fields)

• Is like (string fields)

• Is kind of (object reference)

• Is (object reference)

• Is empty (object reference)

You can use a not operator to logically negate any of your selection criteria.