This API is subject to change. Bug fixes and new features will be released based on developer feedback throughout the preview period.
Adds a sort to a query, sorting by the specified properties in ascending order.
The ascending()
function refines a RulesQueryBuilder
to sort by the value of propertyName
in ascending order.
You can specify multiple properties for sorting in ascending order by passing each property name as an additional argument. ascending()
sorts the results in the order the properties are passed.
You can sort the following types:
'abc'
comes after 'XYZ'
.
If a property contains a number stored as a string (for example, '0'
), that value is sorted alphabetically and not numerically. If a property doesn't have a value, that value is ranked lowest.
Properties used in the sort. To sort by multiple properties, pass properties as additional arguments.
This method doesn’t return any custom errors, but may return standard errors. Learn more about standard Wix errors.
This API is subject to change. Bug fixes and new features will be released based on developer feedback throughout the preview period.
Adds a sort to a query, sorting by the specified properties in descending order.
The descending()
function refines a RulesQueryBuilder
to sort by the value of propertyName
in descending order.
You can specify multiple properties for sorting in descending order by passing each property name as an additional argument. descending()
sorts the results in the order the properties are passed.
You can sort the following types:
'abc'
comes after 'XYZ'
.
If a property contains a number stored as a string (for example, '0'
), that value is sorted alphabetically and not numerically. If a property doesn't have a value, that value is ranked lowest.
Properties used in the sort. To sort by multiple properties, pass properties as additional arguments.
This method doesn’t return any custom errors, but may return standard errors. Learn more about standard Wix errors.
This API is subject to change. Bug fixes and new features will be released based on developer feedback throughout the preview period.
Refines a query to match items where the specified property equals the specified value.
The eq()
function refines a RulesQueryBuilder
to match only items where the value of the specified propertyName
equals the specified value
.
eq()
matches only values of the same type. For example, 0
stored as a number doesn't match '0'
stored as a string.
Matching strings with eq()
is case-sensitive, so 'text'
isn't equal to 'Text'
.
Property whose value is compared with value
.
Value to compare against.
This method doesn’t return any custom errors, but may return standard errors. Learn more about standard Wix errors.
This API is subject to change. Bug fixes and new features will be released based on developer feedback throughout the preview period.
Refines a query to match items where the specified property contains a value.
The exists()
function refines a RulesQueryBuilder
to only match items where the value of the specified propertyName
doesn't equal null or undefined.
exists()
checks for either existence or non-existence based on the boolen parameter. Note that exists()
does match items where the value of the specified propertyName
is an empty string or an invalid value. exists()
is only useful for properties which don't contain default values and therefore their values may be unassigned.
This method doesn’t return any custom errors, but may return standard errors. Learn more about standard Wix errors.
This API is subject to change. Bug fixes and new features will be released based on developer feedback throughout the preview period.
Returns the query results.
The find()
function returns a Promise that resolves to the query results and metadata.
The Promise is rejected if find()
is called with insufficient permissions or if any of the previous functions used to refine the query are invalid.
This method doesn’t return any custom errors, but may return standard errors. Learn more about standard Wix errors.
This API is subject to change. Bug fixes and new features will be released based on developer feedback throughout the preview period.
Refines a query to match items whose specified property contains any of the specified values.
The hasSome()
function refines a RulesQueryBuilder
to match only items where the value of the specified propertyName
equals any of the specified values
.
Matching strings with hasSome()
is case-sensitive, so 'text'
isn't equal to 'Text'
.
If the specified property is an array, hasSome()
matches if any of that array's elements equal any of the specified values.
Property whose value is compared with values
.
This method doesn’t return any custom errors, but may return standard errors. Learn more about standard Wix errors.
This API is subject to change. Bug fixes and new features will be released based on developer feedback throughout the preview period.
Refines a query to only match items where the specified property conatins any of the values in the provided array of values.
The in()
function refines a RulesQueryBuilder
to match only items where the specified propertyName
is equal to any of the values in the provided array.
Matching strings with in()
is case-sensitive, so 'text'
isn't equal to 'Text'
.
This method doesn’t return any custom errors, but may return standard errors. Learn more about standard Wix errors.
This API is subject to change. Bug fixes and new features will be released based on developer feedback throughout the preview period.
Limits the number of items the query returns.
The limit()
function defines the number of results a query returns in each page. Only one page of results is retrieved at a time.
You can use the next()
and prev()
functions to navigate the pages of a query result.
Number of items to return, which is also the pageSize
of the results object.
This method doesn’t return any custom errors, but may return standard errors. Learn more about standard Wix errors.
This API is subject to change. Bug fixes and new features will be released based on developer feedback throughout the preview period.
Refines a query to match items where the specified property doesn't equal the specified value.
The ne()
function refines a RulesQueryBuilder
to match only items where the value of the specified propertyName
doesn't equal the specified value
.
ne()
matches only values of the same type. For example, 0
stored as a number doesn't match '0'
stored as a string.
Matching strings with ne()
is case-sensitive, so 'text'
isn't equal to 'Text'
.
Property whose value is compared with value
.
Value to compare against.
This method doesn’t return any custom errors, but may return standard errors. Learn more about standard Wix errors.
This API is subject to change. Bug fixes and new features will be released based on developer feedback throughout the preview period.
Refines a query that skips to a specific record.
The skipTo()
function refines a RulesQueryBuilder
to return items that appear before or after the item pointed to by the provided cursor. Get the relevant cursor for a specific item from the cursors
object in previous call's response. Then you can skip to cursors.prev
to return items before the cursor, or cursors.next
to return items after the cursor.
When using skipTo()
, the filters and the sorting order of the original query can't be changed. Only the limit()
property of the query can be changed.
A pointer to specific record
This method doesn’t return any custom errors, but may return standard errors. Learn more about standard Wix errors.
This API is subject to change. Bug fixes and new features will be released based on developer feedback throughout the preview period.
Refines a query to match items where the specified property starts with the specified value.
The startsWith()
function refines a RulesQueryBuilder
to match only items where the value of the specified propertyName
starts with the specified string
.
Matching with startsWith()
is case-sensitive, so 'TEXT'
doesn't start with 'text'
.
You can only use startsWith()
with a property whose value is a string.
Property whose value is compared with string
.
This method doesn’t return any custom errors, but may return standard errors. Learn more about standard Wix errors.