Скачать или смотреть Mastering the MongoDB Aggregation Framework: Grouping and Counting Document Statuses

Learn how to efficiently group and count document statuses in `MongoDB` using the aggregation framework. Follow our step-by-step guide for expert insights!
---
This video is based on the question https://stackoverflow.com/q/66173868/ asked by the user 'Pascal' ( https://stackoverflow.com/u/2357245/ ) and on the answer https://stackoverflow.com/a/66174169/ provided by the user 'Dheemanth Bhat' ( https://stackoverflow.com/u/5070460/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: How to group and count with MongoDB aggregation

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
Introduction

If you're working with MongoDB and dealing with collections that contain various document statuses, you may be wondering how to effectively group and count these statuses. For example, you might have a collection with documents that include different statuses like "OPEN", "DONE", and "APPROVED". The goal is to summarize the status count in a structured way. In this post, you'll learn how to achieve this through the powerful aggregation framework in MongoDB.

The Problem

Given a collection with mixed statuses for different documents, the challenge is to display each unique status along with a count of occurrences. Here’s a sample collection structure:

[[See Video to Reveal this Text or Code Snippet]]

You want to transform this into an output like this:

[[See Video to Reveal this Text or Code Snippet]]

The Solution

To accomplish this grouping and counting with MongoDB, you can use the aggregate() function in combination with the $facet operator. Below is a step-by-step breakdown of the aggregated pipeline that will give you the desired output.

Step-by-Step Aggregation

Define the Aggregation Pipeline: Use $facet to create separate pipelines for each document status.

Group Each Status: For every document status (like documentAStatus, documentBStatus, and documentCStatus):

Use $group to count each unique status.

Format the Output:

Add fields to build an array with key-value pairs using $addFields.

Finally, replace the root of the output with these formatted arrays using $replaceRoot.

Here's the complete aggregation query:

[[See Video to Reveal this Text or Code Snippet]]

Expected Output

When executed, this aggregation will produce an output similar to:

[[See Video to Reveal this Text or Code Snippet]]

Conclusion

Using the aggregation framework in MongoDB allows you to elegantly group and count document statuses. The $facet operator is particularly useful when you want to perform multiple operations and present the results in a clear and organized manner.

With this knowledge, you can effectively analyze the statuses in your collections and gain insight into your data. Don't hesitate to apply these techniques in your own projects!