How to get total document count in aggregation pipeline?

Raj

Member

496 Points

21 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: 448
Total Answered: 1
Total Marked As Answer: 1
Posted On: 03-Jun-2022 02:51

Share:

Answers

Smith

None

2568 Points

74 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...

Blog

Steps to Manage SharePoint User Profiles Using Admin Centre

How to Show/Hide i.e. Toggle Password visibility using jQuery and JavaScript?

How do I add consent cookie component in Blazor?

Adding Azure Key Vault secrets in Azure Pipelines

How to get total document count in aggregation pipeline?

Discussion

Blog

Active User (3)