WixDataQuery
Contains functionality for refining a data query. Learn more.
Additional information about this section
Perform actions on an object
- ascending( )
Adds a sort to a query or sort, sorting by the specified properties in ascending order.
- count( )
Returns the number of items that match the query.
- descending( )
Adds a sort to a query or sort, sorting by the specified properties in descending order.
- distinct( )
Returns the distinct values that match the query, without duplicates.
- fields( )
Lists the fields to return in a query's results.
- find( )
Returns the items that match the query.
- include( )
Includes referenced items for the specified properties in a query's results.
- limit( )
Limits the number of items the query returns.
- skip( )
Sets the number of items to skip before returning query results.
- and( )
Adds an and condition to the query or filter.
- between( )
Refines a query or filter to match items whose specified property value is within a specified range.
- contains( )
Refines a query or filter to match items whose specified property value contains a specified string.
- endsWith( )
Refines a query or filter to match items whose specified property value ends with a specified string.
- eq( )
Refines a query or filter to match items whose specified property value equals the specified value.
- ge( )
Refines a query or filter to match items whose specified property value is greater than or equal to the specified value.
- gt( )
Refines a query or filter to match items whose specified property value is greater than the specified value.
- hasAll( )
Refines a query or filter to match items whose specified property values equals all of the specified value parameters.
- hasSome( )
Refines a query or filter to match items whose specified property value equals any of the specified value parameters.
- isEmpty( )
Refines a query or filter to match items whose specified property does not exist or does not have any value.
- isNotEmpty( )
Refines a query or filter to match items whose specified property has any value.
- le( )
Refines a query or filter to match items whose specified property value is less than or equal to the specified value.
- lt( )
Refines a query or filter to match items whose specified property value is less than the specified value.
- ne( )
Refines a query or filter to match items whose specified property value does not equal the specified value.
- not( )
Adds a not condition to the query or filter.
- or( )
Adds an or condition to the query or filter.
- startsWith( )
Refines a query or filter to match items whose specified property value starts with a specified string.