How can I use aggregation in MongoDB with Node.js?

How can I use aggregation in MongoDB with Node.js?

You can use the aggregate method in the MongoDB Node.js driver to perform aggregation operations. Would you like a code example?

Yes, please provide a code example.

Sure! Here's a simple example:

const { MongoClient } = require('mongodb');

async function run() {
    const client = new MongoClient('your_mongodb_uri');
    await client.connect();
    const database = client.db('your_database');
    const collection = database.collection('your_collection');

    const pipeline = [
        { $match: { status: 'A' } },
        { $group: { _id: '$cust_id', total: { $sum: '$amount' } } }
    ];

    const results = await collection.aggregate(pipeline).toArray();
    console.log(results);
    await client.close();
}

run();

What does the $group stage do in this example?

The $group stage is used to group documents by a specified identifier, in this case, cust_id, and it calculates the total amount for each customer.