lt( )

Developer Preview

Refines a query to match items where the specified property is less than the specified value.

Description

The le() function refines a LabelsQueryBuilder to match only items where the value of the specified propertyName is less than the specified value. le() matches only values of the same type. For example, 0 stored as a number doesn't match '0' stored as a string. If a property contains a number stored as a string (for example, '0'), that value is compared alphabetically and not numerically. If a property doesn't have a value, that value is 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 'abc'.

Syntax

function lt(propertyName: string, value: any): LabelsQueryBuilder

lt Parameters

NAME

TYPE

DESCRIPTION

propertyName

Optional

string

Property whose value is compared with value.

value

Optional

any

Value to compare against.

Returns

Return Type:

LabelsQueryBuilder

Was this helpful?

Add an lt filter to a query

Copy Code

1const query = labels.queryLabels.lt('_createdDate', '2021-03-01');
2

Create a query, add an lt filter, and run it

Copy Code

1import { labels } from 'wix-crm.v2';
2
3export async function myQueryFunction() {
4  const results = await labels
5    .queryLabels()
6    .lt('_createdDate', '2021-03-01')
7    .find();
8
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 if no matching items found
21  }
22}
23