Advanced MongoDB Aggregation: Array Aggregation Techniques

The $unwind Stage

$unwind takes an array field and outputs a separate document for each element.

This is useful for flattening nested arrays to perform operations on individual elements.

• Syntax: {$unwind: "$arrayField"}
• Can preserve documents with empty or missing arrays using 'preserveNullAndEmptyArrays' option.

Accumulator Operators: $push and $addToSet

During grouping, $push appends values to an array, including duplicates.

$addToSet adds unique values to an array, preventing duplicates.

• Useful for reconstructing arrays after grouping or filtering.
• Syntax examples: {$push: "$field"}, {$addToSet: "$field"}

Array Expressions for In-Pipeline Manipulation

MongoDB supports expressions like $filter, $map, and $reduce to transform arrays within aggregation stages.

These expressions allow conditional filtering, mapping elements, and reducing arrays to single values.

• $filter: Selects elements matching a condition.
• $map: Transforms each element in an array.
• $reduce: Aggregates array elements into a single value.

Example: Using $unwind to Flatten Arrays

Consider a collection of orders where each document contains an array of items.

Using $unwind, we can process each item individually.

Example: Grouping and Reconstructing Arrays

After unwinding, you might want to group documents back and collect items into arrays.

Using $push or $addToSet helps reconstruct arrays with or without duplicates.

Example: Filtering Array Elements with $filter

You can filter array elements based on conditions inside the aggregation pipeline using $filter.

This avoids the need to unwind arrays when only a subset of elements is needed.