How to get total document count in aggregation pipeline?

Raj

648 Points

26 Posts

I'm trying following query:

db.getCollection('permission').aggregate([
   { $match: { "accountId": "my-account" } },
   { $group: { _id: "$accountId", "totalCount": { $sum: 1 } } }
])

It's showing total account wise but I want total count of all document in permission.

mongodb mongodb-driver

Views: 561
Total Answered: 1
Total Marked As Answer: 1
Posted On: 03-Jun-2022 02:51

Share:

Answers

Smith

2926 Points

78 Posts

Try to put null in _id as:

db.getCollection('permission').aggregate([
   { $group: { _id: null, "totalCount": { $sum: 1 } } }
])

Posted On: 12-Jun-2022 22:23

thanks

- Raj 01-Aug-2022 23:08

Discussion

SignalR for real-time web functionality

MVC Design pattern

What is the current status of artif...

Modern Web Development using ASP.NE...

Is Programming an Art or a Science?

Blazor is a UI Web framework for bu...

Generative AI refers to artificial ...

How to open OST files without Exch...

Blog

How to Complete Your SIR (Special Intensive Revision) Online: Simple Guide with Visuals?

How to Create a Modern Web App Using Angular and ASP.NET Core 9 (with VS Code)?

Migrating ASP.NET Core 8.0 to 9.0 – A Comprehensive Guide

Semantic Kernel vs AI library in .NET

How to get total document count in aggregation pipeline?

Discussion

Blog

Active User (19)