For which types of fields in the prefilter is intervals available?
For types:
Number
Select
Date
Does the value in the prefilter include the range from and to?
Yes, it is included.
What happens if "from" is set and "to" is not?
In this case, to will not be considered, so we will get all rows where the value of the linked field is greater than or equal to from.
Is the order different for strings and numbers?
Dates are compared as dates.
If in the string part the prefilter is bound to a string field where values similar to numbers are entered — that is, they consist of digits, and a dot is used as the decimal separator — then the comparison is done as with numbers.
That is, 555 will be greater than 6.
If the field value in the string part contains letters, digits and letters, or the decimal separator ,, then the comparison will be as with strings:
That is, 555 will be less than 6.