Refines a query to match items whose specified property value is within a specified range.
The between()
function refines a PublicPlansQueryBuilder
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. When sorting, ascending order is: numbers, followed by symbols, and then letters.
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.function between(
propertyName: string,
rangeStart: union,
rangeEnd: union,
): PublicPlansQueryBuilder;
The property whose value will be compared with rangeStart
and rangeEnd
.
Supported properties:
_createdDate
_updatedDate
The beginning value of the range to match against.
The ending value of the range to match against.
const now = new Date();
const date = new Date("2020-11-01");
const query = wixPricingPlansBackend
.queryPublicPlans()
.between("_createdDate", date, now);
This method doesn’t return any custom errors, but may return standard errors. Learn more about standard Wix errors.