$mustNot - Upstash Documentation

The $mustNot operator excludes documents that match any of the specified conditions.

How $mustNot works depends on the other conditions next to it:

With other conditions, such as $must or a field condition: $mustNot filters the matching documents. It removes the documents that match its conditions.
On its own: the query matches every document that $mustNot does not exclude. All of these documents have a score of 0.
Inside $should: $mustNot is one of the alternatives. It matches every document it does not exclude, with a score of 0.

// Matches all documents except electronics, with a score of 0{ $mustNot: { category: "electronics" } }// Matches in-stock documents, except electronics{ $must: { inStock: true }, $mustNot: { category: "electronics" } }// Matches headphones, and every document that is not electronics with a score of 0{ $should: [{ name: "headphones" }, { $mustNot: { category: "electronics" } }] }

Excluding Multiple Conditions#

When $mustNot contains multiple conditions (via array or object), documents matching ANY of those conditions are excluded. This is effectively an OR within the exclusion:

// Exclude documents that match category="generic" OR price > 500{ $mustNot: [{ category: "generic" }, { price: { $gt: 500 } }] }

Examples#

// Exclude out-of-stock itemsawait products.query({  filter: {    $must: {      category: "electronics",    },    $mustNot: {      inStock: false,    },  },});// Exclude multiple conditionsawait products.query({  filter: {    $must: {      name: "headphones",    },    $mustNot: [{ category: "generic" }, { price: { $gt: 500 } }],  },});

# Exclude out-of-stock itemsproducts.query(filter={"$must": {"category": "electronics"}, "$mustNot": {"inStock": False}})# Exclude multiple conditionsproducts.query(filter={    "$must": {"name": "headphones"},    "$mustNot": [{"category": "generic"}, {"price": {"$gt": 500}}],})

# Exclude out-of-stock itemsSEARCH.QUERY products '{"$must": {"category": "electronics"}, "$mustNot": {"inStock": false}}'# Exclude multiple conditionsSEARCH.QUERY products '{"$must": {"name": "headphones"}, "$mustNot": [{"category": "generic"}, {"price": {"$gt": 500}}]}'