ne( )

Refines a query or filter to match items whose specified property value does not equal the specified value.

Description

The ne() function refines a WixDataQuery or WixDataFilter to only match items where the value of the specified property does not equal the specified value.

It only matches values of the same type. For example, a number value stored as a String type is considered not equal to the same number stored as a Number type.

Matching strings with ne() is case sensitive, so "text" is not equal to "Text".

If the value of the propertyName property is an Array, ne() includes items in which none of the elements of the Array match the specified value.

Syntax

function ne(propertyName: string, value: *): WixDataQuery

ne Parameters

NAME

TYPE

DESCRIPTION

propertyName

string

The property whose value will be compared with value.

value

The value to match against.

Returns

A WixDataQuery object representing the refined query.

Return Type:

WixDataQuery

Mixed in from:wix-data.WixDataFilter

Was this helpful?

Add a not equals filter to a query

Copy Code

1let newQuery = query.ne("status", "active");

Create a query, add a not equals filter, and run it

Copy Code

1import wixData from 'wix-data';
2
3// ...
4
5wixData.query("myCollection")
6  .ne("status", "active")
7  .find()
8  .then((results) => {
9    if(results.items.length > 0) {
10      let items = results.items;
11      let firstItem = items[0];
12      let totalCount = results.totalCount;
13      let pageSize = results.pageSize;
14      let currentPage = results.currentPage;
15      let totalPages = results.totalPages;
16      let hasNext = results.hasNext();
17      let hasPrev = results.hasPrev();
18      let length = results.length;
19      let query = results.query;
20    } else {
21      // handle case where no matching items found
22    }
23  })
24  .catch((error) => {
25    let errorMsg = error.message;
26    let code = error.code;
27  });

Create a query, add a not equals filter, and run it

Copy Code

1import wixData from 'wix-data';
2
3// ...
4
5wixData.query("myCollection")
6  .ne("status", "active")
7  .gt("age", 25)
8  .ascending("last_name", "first_name")
9  .limit(10)
10  .find()
11  .then((results) => {
12    if(results.items.length > 0) {
13      let items = results.items;
14      let firstItem = items[0];
15      let totalCount = results.totalCount;
16      let pageSize = results.pageSize;
17      let currentPage = results.currentPage;
18      let totalPages = results.totalPages;
19      let hasNext = results.hasNext();
20      let hasPrev = results.hasPrev();
21      let length = results.length;
22      let query = results.query;
23    } else {
24      // handle case where no matching items found
25    }
26  })
27  .catch((error) => {
28    let errorMsg = error.message;
29    let code = error.code;
30  });