/ /

$count (operador de acumulación)

Definición

Nuevo en la versión 5.0.

$count

Devuelve la cantidad de documentos en un grupo.

$count está disponible en estas etapas:

$bucket
$bucketAuto
$group
$setWindowFields (Disponible a partir de MongoDB 5.0)

Nota

Desambiguación

This page describes the $count aggregation accumulator. For the $count aggregation pipeline stage, see $count (aggregation pipeline).

Sintaxis

$count sintaxis:

{ $count: { } }

$count no admite ningún parámetro.

Comportamiento

$count is functionally equivalent to using { $sum : 1 } within the $group stage.

Tip

$sum

Ejemplos

Crea una colección de cakeSales que incluya ventas de pasteles en el estado de California (CA) y Washington (WA):

db.cakeSales.insertMany( [
   { _id: 0, type: "chocolate", orderDate: new Date("2020-05-18T14:10:30Z"),
     state: "CA", price: 13, quantity: 120 },
   { _id: 1, type: "chocolate", orderDate: new Date("2021-03-20T11:30:05Z"),
     state: "WA", price: 14, quantity: 140 },
   { _id: 2, type: "vanilla", orderDate: new Date("2021-01-11T06:31:15Z"),
     state: "CA", price: 12, quantity: 145 },
   { _id: 3, type: "vanilla", orderDate: new Date("2020-02-08T13:13:23Z"),
     state: "WA", price: 13, quantity: 104 },
   { _id: 4, type: "strawberry", orderDate: new Date("2019-05-18T16:09:01Z"),
     state: "CA", price: 41, quantity: 162 },
   { _id: 5, type: "strawberry", orderDate: new Date("2019-01-08T06:12:03Z"),
     state: "WA", price: 43, quantity: 134 }
] )

La colección cakeSales se utiliza en los siguientes ejemplos.

Uso en la etapa `$group`

This example uses $count in the $group stage to count the number of documents in the cakeSales collection for each state:

db.cakeSales.aggregate( [
   {
      $group: {
         _id: "$state",
         countNumberOfDocumentsForState: {
            $count: {}
         }
      }
   }
] )

En el ejemplo:

_id: "$state" agrupa los documentos por el valor del campo state. Hay grupos para CA y WA.
$count: {} establece el campo countNumberOfDocumentsForState en el número de documentos que comparten el mismo valor de campo state.

En este resultado, se muestra el número de documentos para CA y WA en el campo countNumberOfDocumentsForState:

{ "_id" : "CA", "countNumberOfDocumentsForState" : 3 }
{ "_id" : "WA", "countNumberOfDocumentsForState" : 3 }

Uso en la etapa `$setWindowFields`

This example uses $count in the $setWindowFields stage to count the number of documents in the cakeSales collection for each state defined in the window:

db.cakeSales.aggregate( [
   {
      $setWindowFields: {
         partitionBy: "$state",
         sortBy: { orderDate: 1 },
         output: {
            countNumberOfDocumentsForState: {
               $count: {},
               window: {
                  documents: [ "unbounded", "current" ]
               }
            }
         }
      }
   }
] )

En el ejemplo:

partitionBy: "$state" particiona los documentos de la colección en state. Existen particiones para CA y WA.
sortBy: { orderDate: 1 } ordena los documentos de cada partición por orderDate en orden ascendente (1), de modo que el orderDate más antiguo sea el primero.

output sets the countNumberOfDocumentsForState field to the number of documents using $count that is run in a documents window.

The window contains documents between an unbounded lower limit and the current document in the output. This means $count returns the number of documents between the beginning of the partition and the current document.

En este resultado, se muestra el número de documentos para CA y WA en el campo countNumberOfDocumentsForState:

{ "_id" : 4, "type" : "strawberry", "orderDate" : ISODate("2019-05-18T16:09:01Z"),
  "state" : "CA", "price" : 41, "quantity" : 162, "countNumberOfDocumentsForState" : 1 }
{ "_id" : 0, "type" : "chocolate", "orderDate" : ISODate("2020-05-18T14:10:30Z"),
  "state" : "CA", "price" : 13, "quantity" : 120, "countNumberOfDocumentsForState" : 2 }
{ "_id" : 2, "type" : "vanilla", "orderDate" : ISODate("2021-01-11T06:31:15Z"),
  "state" : "CA", "price" : 12, "quantity" : 145, "countNumberOfDocumentsForState" : 3 }
{ "_id" : 5, "type" : "strawberry", "orderDate" : ISODate("2019-01-08T06:12:03Z"),
  "state" : "WA", "price" : 43, "quantity" : 134, "countNumberOfDocumentsForState" : 1 }
{ "_id" : 3, "type" : "vanilla", "orderDate" : ISODate("2020-02-08T13:13:23Z"),
  "state" : "WA", "price" : 13, "quantity" : 104, "countNumberOfDocumentsForState" : 2 }
{ "_id" : 1, "type" : "chocolate", "orderDate" : ISODate("2021-03-20T11:30:05Z"),
  "state" : "WA", "price" : 14, "quantity" : 140, "countNumberOfDocumentsForState" : 3 }

Volver

$bottomN

$first