Refines a query or filter to match items whose specified property value is within a specified range.
The between()
function refines a WixDataQuery
or WixDataFilter
to only
match items where the value of the specified property is greater than or equal
to rangeStart
and less than rangeEnd
.
It only matches values of the same type. For example, a number value stored as a String type does not match the same number stored as a Number type.
If a property contains a number as a String, that value will be compared alphabetically and not numerically. Items that do not have a value for the specified property are ranked lowest.
The following types of properties can be compared:
"A"
and "M"
are between "A"
and "Z"
, but "a"
, "m"
, "z"
and "Z"
are not."A"
, "M"
, "Z"
, and "a"
are between "A"
and "z"
, but "z"
is not.
The property whose value will be compared with rangeStart
and rangeEnd
.
The beginning value of the range to match against.
The ending value of the range to match against.