ne( )

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

Description

The ne() function refines a MembershipsQueryBuilder 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 does not match the same number stored as a Number type.

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

Syntax

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

ne Parameters

NAME

TYPE

DESCRIPTION

propertyName

string

The property whose value will be compared with value.

Supported property:

role

value

The value to match against.

Returns

A MembershipsQueryBuilder object representing the refined query.

Return Type:

MembershipsQueryBuilder

Was this helpful?

Add a not equals filter to a query

Copy Code

1const query = members.queryMemberships().ne("status", "PENDING");

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

Copy Code

1import { Permissions, webMethod } from 'wix-web-module';
2import { members } from 'wix-groups-backend';
3
4export const myQueryMembershipsFunction = webMethod(Permissions.Anyone, () => {
5  return members.queryMemberships()
6    .ne("status", "PENDING")
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 totalPages = results.totalPages;
14        const totalCount = results.totalCount;
15        const currentPage = results.currentPage();
16        const next = results.next();
17        const previous = results.prev();
18        const hasNext = results.hasNext();
19        const hasPrev = results.hasPrev();
20        const length = results.length;
21
22        return items;
23      } else {
24        // Handle case where no matching items found
25      }
26    })
27    .catch((error) => {
28      console.error(error);
29    })
30
31});