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.