$nor operator behavior in MongoDB - Mini Project: Build & Apply

$nor Operator Behavior in MongoDB Queries

📖 Scenario: You are managing a small online bookstore database. You want to find books that do not match certain conditions, such as not being in a specific genre and not having a rating above a certain value.

🎯 Goal: Build a MongoDB query using the $nor operator to find books that do not meet either of two conditions.

📋 What You'll Learn

Create a collection called books with 4 documents having fields title, genre, and rating.

Create a variable called queryConditions that holds an array of two conditions: one for genre equal to Fantasy, and one for rating greater than 4.5.

Write a MongoDB query using $nor with queryConditions to find books that are neither Fantasy genre nor have a rating above 4.5.

Assign the final query object to a variable called finalQuery.

💡 Why This Matters

🌍 Real World

Filtering data in MongoDB to exclude certain categories or values is common in applications like online stores, libraries, or user management systems.

💼 Career

Understanding $nor helps you write complex queries to retrieve exactly the data you need, a valuable skill for backend developers and data analysts working with MongoDB.

1

Create the books collection with sample documents

Create a variable called books and assign it an array with these exact 4 documents: { title: 'The Hobbit', genre: 'Fantasy', rating: 4.8 }, { title: '1984', genre: 'Dystopian', rating: 4.6 }, { title: 'Clean Code', genre: 'Programming', rating: 4.7 }, and { title: 'Cooking 101', genre: 'Cooking', rating: 4.2 }.

MongoDB

// Create the books array with 4 documents
// Your code here

Hint

Use an array of objects with the exact field names and values.

2

Create the queryConditions array with two conditions

Create a variable called queryConditions and assign it an array with two objects: one with { genre: 'Fantasy' } and the other with { rating: { $gt: 4.5 } }.

MongoDB

const books = [
  { title: 'The Hobbit', genre: 'Fantasy', rating: 4.8 },
  { title: '1984', genre: 'Dystopian', rating: 4.6 },
  { title: 'Clean Code', genre: 'Programming', rating: 4.7 },
  { title: 'Cooking 101', genre: 'Cooking', rating: 4.2 }
];

// Create queryConditions array with two conditions
// Your code here

Hint

Use an array with two objects exactly as shown.

3

Write the MongoDB query using $nor with queryConditions

Create a variable called finalQuery and assign it an object with the $nor operator using the queryConditions array.

MongoDB

const books = [
  { title: 'The Hobbit', genre: 'Fantasy', rating: 4.8 },
  { title: '1984', genre: 'Dystopian', rating: 4.6 },
  { title: 'Clean Code', genre: 'Programming', rating: 4.7 },
  { title: 'Cooking 101', genre: 'Cooking', rating: 4.2 }
];

const queryConditions = [
  { genre: 'Fantasy' },
  { rating: { $gt: 4.5 } }
];

// Create finalQuery using $nor with queryConditions
// Your code here

Hint

Use an object with $nor as the key and queryConditions as the value.

4

Complete the query setup for use in MongoDB

Add a comment above finalQuery explaining that this query finds books that are neither Fantasy genre nor have a rating above 4.5.

MongoDB

const books = [
  { title: 'The Hobbit', genre: 'Fantasy', rating: 4.8 },
  { title: '1984', genre: 'Dystopian', rating: 4.6 },
  { title: 'Clean Code', genre: 'Programming', rating: 4.7 },
  { title: 'Cooking 101', genre: 'Cooking', rating: 4.2 }
];

const queryConditions = [
  { genre: 'Fantasy' },
  { rating: { $gt: 4.5 } }
];

// Add a comment explaining the purpose of finalQuery
const finalQuery = { $nor: queryConditions };

Hint

Write a clear comment above the finalQuery variable.

Practice

1. What does the $nor operator do in MongoDB queries?

easy

A. Finds documents where all specified conditions are true

B. Finds documents where at least one condition is true

C. Finds documents where none of the specified conditions are true

D. Finds documents that match exactly one condition

Solution

1. Step 1: Understand the purpose of $nor

   The $nor operator returns documents that do not satisfy any of the given conditions.

2. Step 2: Compare with other logical operators

   Unlike $and or $or, $nor excludes documents matching any condition in its array.

3. Final Answer:

   Finds documents where none of the specified conditions are true -> Option C

4. Quick Check:

   $nor excludes all matching conditions = B [OK]

Hint: Think: no conditions should be true for $nor [OK]

Common Mistakes:

• Confusing $nor with $or
• Assuming it returns documents matching any condition
• Thinking it requires all conditions to be true

2. Which of the following is the correct syntax to use $nor in a MongoDB query to exclude documents where age is 25 or status is "active"?

easy

A. { $nor: { $or: [ { age: 25 }, { status: "active" } ] } }

B. { $nor: { age: 25, status: "active" } }

C. { $nor: [ age: 25, status: "active" ] }

D. { $nor: [ { age: 25 }, { status: "active" } ] }

Solution

1. Step 1: Recall $nor syntax

   $nor requires an array of condition objects inside square brackets.

2. Step 2: Check each option's structure

   { $nor: [ { age: 25 }, { status: "active" } ] } correctly uses an array of conditions. Options B and D use objects incorrectly, and C has invalid array syntax.

3. Final Answer:

   { $nor: [ { age: 25 }, { status: "active" } ] } -> Option D

4. Quick Check:

   Array of conditions inside $nor = A [OK]

Hint: Use square brackets for conditions array in $nor [OK]

Common Mistakes:

• Using curly braces instead of square brackets for conditions
• Passing a single object instead of an array
• Nesting $or inside $nor unnecessarily

3. Given the collection documents:

[{ "name": "Alice", "age": 30, "status": "active" }, { "name": "Bob", "age": 25, "status": "inactive" }, { "name": "Carol", "age": 35, "status": "active" }]

What will be the result of this query?

{ $nor: [ { age: 25 }, { status: "active" } ] }

medium

A. [] (empty array)

B. [{ "name": "Bob", "age": 25, "status": "inactive" }]

C. [{ "name": "Bob", "age": 25, "status": "inactive" }, { "name": "Carol", "age": 35, "status": "active" }]

D. [{ "name": "Bob", "age": 25, "status": "inactive" }, { "name": "Alice", "age": 30, "status": "active" }]

Solution

1. Step 1: Understand the $nor conditions

   The query excludes documents where age is 25 OR status is "active".

2. Step 2: Check each document against conditions

   Alice: status "active" -> excluded; Bob: age 25 -> excluded; Carol: status "active" -> excluded.

3. Final Answer:

   [] (empty array) -> Option A

4. Quick Check:

   All documents match at least one condition, so none returned = A [OK]

Hint: Exclude any document matching any condition in $nor [OK]

Common Mistakes:

• Returning documents that match one condition
• Confusing $nor with $or
• Assuming some documents pass when all match conditions

4. You wrote this MongoDB query but it throws an error:

{ $nor: { age: { $gt: 30 }, status: "inactive" } }

What is the problem and how to fix it?

medium

A. The field names must be strings; fix: { $nor: [ { "age": { $gt: 30 } }, { "status": "inactive" } ] }

B. The conditions must be inside an array; fix: { $nor: [ { age: { $gt: 30 } }, { status: "inactive" } ] }

C. The operator $gt is invalid; fix: use $gte instead

D. The query must use $and instead of $nor

Solution

1. Step 1: Identify the syntax error

   $nor expects an array of condition objects, but here it has a single object.

2. Step 2: Correct the syntax

   Wrap each condition inside its own object within an array to fix the error.

3. Final Answer:

   The conditions must be inside an array; fix: { $nor: [ { age: { $gt: 30 } }, { status: "inactive" } ] } -> Option B

4. Quick Check:

   $nor needs array of conditions = C [OK]

Hint: Always use an array of conditions with $nor [OK]

Common Mistakes:

• Passing a single object instead of an array
• Misusing comparison operators
• Confusing $nor with $and

5. You have a collection with documents:

[{ "item": "pen", "qty": 10, "status": "A" }, { "item": "pencil", "qty": 5, "status": "D" }, { "item": "notebook", "qty": 15, "status": "A" }, { "item": "eraser", "qty": 0, "status": "D" }]

Write a $nor query to find documents where qty is not 0 and status is not "D". Which query returns the correct documents?

hard

A. { $nor: [ { qty: 0 }, { status: "D" } ] }

B. { $nor: [ { qty: { $ne: 0 } }, { status: { $ne: "D" } } ] }

C. { $nor: [ { qty: { $eq: 0 } }, { status: { $ne: "D" } } ] }

D. { $nor: [ { qty: { $gt: 0 } }, { status: { $ne: "D" } } ] }

Solution

1. Step 1: Understand the requirement

   We want documents where qty is NOT 0 and status is NOT "D".

2. Step 2: Use $nor to exclude documents with qty 0 or status "D"

   { $nor: [ { qty: 0 }, { status: "D" } ] } excludes documents with qty 0 or status "D", so it returns documents matching the requirement.

3. Final Answer:

   { $nor: [ { qty: 0 }, { status: "D" } ] } -> Option A

4. Quick Check:

   Exclude unwanted values with $nor = D [OK]

Hint: Use $nor to exclude unwanted values directly [OK]

Common Mistakes:

• Using $ne inside $nor incorrectly
• Confusing inclusion with exclusion logic
• Using wrong comparison operators inside conditions