Quick filter reference
Quick filters are predefined filter options that can be used in a List. The available quick filters depend on the field type.
If the item is not a number, the following filters are available:
Is equal to
Is not equal to
Is empty
Is not empty
If the item is a number, the following filters are available:
Is between
Is not between
Is empty
Is not empty
Is greater than
Is smaller than
You need to select a range for some options because numbers are sometimes shown rounded in the Display. In that case, they are not exactly the same values as the corresponding values in the database, and a match cannot be found. To prevent this situation, ranges have been added.
The range of the numbers used for the filter depends on your decimal settings (see Specifying the data formats). It is determined as follows:
To determine the lower bound, subtract 1 from the last visible digit and add a 5 after it.
To determine the upper bound, add a 5 after the last visible original digit.
Examples:
1.23k:
Lower bound: Subtract 1 from the last digit: 1.22k. Add a 5: 1.225k
Upper bound: Add a 5: 1.235k
The range is 1.225k-1.235k (1225-1235).
1230:
Lower bound: Subtract 1 from the last digit: 1229. Now add a 5 after it (don't forget the decimal point): 1229.5
Upper bound: add a 5. Don't forget the decimal point: 1230.5
The range is 1229.5-1230.5.
1.2m: the range is between 1.15m and 1.25m (1150000-1250000)
1k: the range is between 0.5k and 1.5k (500-1500).