Search.../

le( )

Refines a query to match items whose specified property value is less than or equal to the specified value.

Description

The le() function refines a ContactsQueryBuilder to only match items where the value of the specified property is less than or equal to the specified value.

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:

  • Number: Compares numerically.
  • Date: Compares JavaScript Date objects.
  • String: Compares lexicographically,

so "ABC" is less than or equal to "abc" (because of the less than), but "abc" is not less than or equal to "ABC".

Syntax

function le(propertyName: string, value: Date): ContactsQueryBuilder

le Parameters

NAME
TYPE
DESCRIPTION
propertyName
string

The property whose value will be compared with value.

Supported properties:

  • "_createdDate"
  • "_updatedDate"
  • "lastActivity.activityDate"
  • "info.birthdate"
value
Date

The value to match against.

Returns

A ContactsQueryBuilder object that contains the refined query.

Was this helpful?

Add an le filter to a query

Copy Code
1const query = contacts.queryContacts().le("_createdDate", "2021-01-01T00:00:00.000Z");
Create a query, add an le filter, and run it

Copy Code
1import { Permissions, webMethod } from 'wix-web-module';
2import { contacts } from 'wix-crm-backend';
3
4export const myQueryContactsFunction = webMethod(Permissions.Anyone, () => {
5 return contacts.queryContacts()
6 .le("info.birthdate", "1990-01-01")
7 .find()
8 .then((results) => {
9 if (results.items.length > 0) {
10 const items = results.items;
11 const firstItem = items[0];
12 const pageSize = results.pageSize;
13 const hasNext = results.hasNext();
14 const hasPrev = results.hasPrev();
15 const length = results.length;
16 const query = results.query;
17
18 return items;
19 } else {
20 // Handle case where no matching items found
21 }
22 })
23 .catch((error) => {
24 console.error(error);
25 })
26
27});