Intro to Mongoose Advanced Querying

Learning objective: By the end of this lesson, students will be able to implement advanced querying techniques in MongoDB using Mongoose.

Mongoose and MongoDB offer various tools for retrieving data based on complex criteria. These more advanced querying techniques can be useful for optimizing your applications or implementing robust searching and filtering features.

One example of an advanced querying technique is using regex within a find() operation.

const todos = await Todo.find({ text: /learn/i });

In the example above, we use a regex pattern to find all todos where the text field contains the word ‘learn’, regardless of case sensitivity. The pattern within the regex is defined between the two / symbols. In /learn/i, ‘learn’ is the pattern we’re matching against, and the i at the end makes the search case-insensitive. This means it will match ‘Learn’, ‘LEARN’, ‘learn’, and any other variations of the word. This approach can be particularly useful if you wish to implement search functionality.

📚 Regular expressions, or regex for short, are patterns used to match character combinations in strings. Regular expressions are a standard feature in many programming languages and tools, not specific to Mongoose or MongoDB.

In addition to regex, Mongoose can utilize MongoDB operators for advanced querying. Let’s explore two key categories of these operators: logical and comparison.

Logical operators

MongoDB logical operators are used to query with multiple conditions. With logical operators, we can conduct more targeted searches in the database.

Some commonly used logical operators include:

• $and: Combines multiple conditions that must all be true.
• $or: Combines multiple conditions and checks if at least one of the conditions is true.
• $not: Returns documents that do not meet the condition.

You can view a full list of logical operators in the MongoDB documentation.

Comparison operators

MongoDB comparison operators are used to compare values against one another. Comparison operators determine whether the value held in a document’s field matches a certain condition. The condition is specified by the operator itself. If the condition is met, the document is included in the results of the query.

For example, using the $eq operator, MongoDB will return documents where the field in question equals a specified value. Similarly, $gt can be used to return documents where the field’s value is greater than a specified value.

For example:

// Query to find items where price is greater than 20

const items = await Item.find({ 
  price: { $gt: 20 } 
});

Some commonly used comparison operators include:

• $eq: Returns documents where a target field equals the specified value.
• $gt: Returns documents where a target field is greater than a specified value.
• $gte: Returns documents where a target field is greater than or equal to a specified value.
• $nin: Returns documents that do not contain a certain value in their target array field.

You can view a full list of comparison operators in the MongoDB documentation.