Examples of Using Operators for Filtering
This chapter describes examples of using the operators that can be found in chapter Filtering records in a search table.
 |
CASE SUMMARY
We will look at how the different operators work, using the Item criterion as an example. The operators we will describe are:
- Equals
- Not equal
- Contains
- Starts with
- Ends with
- From including to including (range)
- Greater than or equal to
- Less than or equal to
|
1. Equals
Using this criterion and the specified string of records in the register, the data will be filtered to exactly one record (selected).
2. Not equal
Using this criterion and the specified string of records in the register, the data will be filtered to all records except one (the selected one).
3. Contains
Using this criterion and the specified string of records in the register, the data will be filtered to all records that contain the selected string in their name.
4. Starts with
Using this criterion and the specified string of records in the register, the data will be filtered to records that start with the same string.
5. Ends with
Using this criterion and the specified string of records in the register, the data will be filtered to records that end with the same string.
6. From including to including (range)
Using this criterion and the specified string of records in the register, the data will be filtered to records with the same range.
- greater than or equal to the first selected record (from field)
- less than or equal to the second selected record (the to field)
7. Greater than or equal to
Using this criterion and the specified string of records in the register, the data will be filtered to all records that are greater than or equal to the selected one.
8. Less than or equal to
Using this criterion and the specified string of records in the register, the data will be filtered to all records that are less than or equal to the selected one.
