---
name: "mongoc_database_aggregate"
section: "3"
platform: "linux"
package: "libmongoc-doc"
version: "1.30.4-1+deb13u3"
release: "Debian 13 (Trixie)"
platforms: ["linux"]
url: "https://new.carta.tech/mongoc_database_aggregate"
---

# mongoc\_database\_aggregate(3)

## SYNOPSIS

```
mongoc_cursor_t *
mongoc_database_aggregate (mongoc_database_t *database,
                           const bson_t *pipeline,
                           const bson_t *opts,
                           const mongoc_read_prefs_t *read_prefs);
```

## PARAMETERS

- •

  **database**: A *mongoc\_database\_t*.

- •

  **pipeline**: A *bson\_t*, either a BSON array or a BSON document containing an array field named "pipeline".

- •

  **opts**: A *bson\_t* containing options for the command, or **NULL**.

- •

  **read\_prefs**: A *mongoc\_read\_prefs\_t* or **NULL**.

**opts** may be NULL or a BSON document with additional command options:

- •

  **readConcern**: Construct a *mongoc\_read\_concern\_t* and use *mongoc\_read\_concern\_append()* to add the read concern to **opts**. See the example code for *mongoc\_client\_read\_command\_with\_opts()*. Read concern requires MongoDB 3.2 or later, otherwise an error is returned.

- •

  **writeConcern**: Construct a *mongoc\_write\_concern\_t* and use *mongoc\_write\_concern\_append()* to add the write concern to **opts**. See the example code for *mongoc\_client\_write\_command\_with\_opts()*.

- •

  **sessionId**: First, construct a *mongoc\_client\_session\_t* with *mongoc\_client\_start\_session()*. You can begin a transaction with *mongoc\_client\_session\_start\_transaction()*, optionally with a *mongoc\_transaction\_opt\_t* that overrides the options inherited from **database**, and use *mongoc\_client\_session\_append()* to add the session to **opts**. See the example code for *mongoc\_client\_session\_t*.

- •

  **bypassDocumentValidation**: Set to **true** to skip server-side schema validation of the provided BSON documents.

- •

  **collation**: Configure textual comparisons. See *Setting Collation Order*, and *the MongoDB Manual entry on Collation*. Collation requires MongoDB 3.2 or later, otherwise an error is returned.

- •

  **serverId**: To target a specific server, include an int32 "serverId" field. Obtain the id by calling *mongoc\_client\_select\_server()*, then *mongoc\_server\_description\_id()* on its return value.

- •

  **batchSize**: An **int32** representing number of documents requested to be returned on each call to *mongoc\_cursor\_next()*

- •

  **let**: A BSON document consisting of any number of parameter names, each followed by definitions of constants in the MQL Aggregate Expression language.

- •

  **comment**: A *bson\_value\_t* specifying the comment to attach to this command. The comment will appear in log messages, profiler output, and currentOp output. Only string values are supported prior to MongoDB 4.4.

- •

  **hint**: A document or string that specifies the index to use to support the query predicate.

For a list of all options, see *the MongoDB Manual entry on the aggregate command*.

## DESCRIPTION

This function creates a cursor which sends the aggregate command on the underlying database upon the first call to *mongoc\_cursor\_next()*. For more information on building aggregation pipelines, see *the MongoDB Manual entry on the aggregate command*. Note that the pipeline must start with a compatible stage that does not require an underlying collection (e.g. "$currentOp", "$listLocalSessions").

Read preferences, read and write concern, and collation can be overridden by various sources. The highest-priority sources for these options are listed first in the following table. In a transaction, read concern and write concern are prohibited in **opts** and the read preference must be primary or NULL. Write concern is applied from **opts**, or if **opts** has no write concern and the aggregation pipeline includes "$out", the write concern is applied from **database**.

| | | | |
| --- | --- | --- | --- |
| Read Preferences | Read Concern | Write Concern | Collation |
| **read\_prefs** | **opts** | **opts** | **opts** |
| Transaction | Transaction | Transaction |  |
| **database** | **database** | **database** |  |

*See the example for transactions* and for *the "distinct" command with opts*.

This function is considered a retryable read operation unless the pipeline contains a write stage like $out or $merge. Upon a transient error (a network error, errors due to replica set failover, etc.) the operation is safely retried once. If **retryreads** is false in the URI (see *mongoc\_uri\_t*) the retry behavior does not apply.

## RETURNS

This function returns a newly allocated *mongoc\_cursor\_t* that should be freed with *mongoc\_cursor\_destroy()* when no longer in use. The returned *mongoc\_cursor\_t* is never **NULL**, even on error. The user must call *mongoc\_cursor\_next()* on the returned *mongoc\_cursor\_t* to execute the initial command.

Cursor errors can be checked with *mongoc\_cursor\_error\_document()*. It always fills out the *bson\_error\_t* if an error occurred, and optionally includes a server reply document if the error occurred server-side.

**WARNING:**

Failure to handle the result of this function is a programming error.

## EXAMPLE

```
#include <bson/bson.h>
#include <mongoc/mongoc.h>
static mongoc_cursor_t *
current_op_query (mongoc_client_t *client)
{
   mongoc_cursor_t *cursor;
   mongoc_database_t *database;
   bson_t *pipeline;
   pipeline = BCON_NEW ("pipeline",
                        "[",
                        "{",
                        "$currentOp",
                        "{",
                        "}",
                        "}",
                        "]");
   /* $currentOp must be run on the admin database */
   database = mongoc_client_get_database (client, "admin");
   cursor = mongoc_database_aggregate (
      database, pipeline, NULL, NULL);
   bson_destroy (pipeline);
   mongoc_database_destroy (database);
   return cursor;
}
```

## AUTHOR

MongoDB, Inc

## COPYRIGHT

2009-present, MongoDB, Inc.