How to get total document count in aggregation pipeline?

Raj

Member

54 Points

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

Share:

Answers

Smith

Moderator

738 Points

154 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

Modern Web Development using ASP.NE...

Is Programming an Art or a Science?

Blog

How to migrate ASP.NET core 3.1 to ASP.NET 6.0

How to read response cookies using System.Net.Http.HttpClient?

MongoDB Aggregation Array to Object Id with Three Collections (Many-to-One-to-One) using Lookup

How to Create Online Quiz or Online Test Free on NiceOneCode?

How to get total document count in aggregation pipeline?

Discussion

Blog

Active User (3)