Breaking News: Grepper is joining You.com. Read the official announcement!

aggregate in mongoose express node.js

Add Answer

Shirshak Kandel answered on November 10, 2020 Popularity 10/10 Helpfulness 3/10

answer aggregate in mongoose express node.js

related aggregate mongoose example

related how to use mongoose aggregate

aggregate in mongoose express node.js

Comment

//routes/tourRouter.js
router.route('/tour-stats').get(tourController.getTourStats);

//controller/tourController.js
//NOTES::Aggregation pipeline to get tours stats
exports.getTourStats = async (req, res) => {
  try {
    const stats = await Tour.aggregate([
      {
        $match: { ratingsAverage: { $gte: 4.5 } },
      },
      {
        $group: {
          _id: { $toUpper: '$difficulty' },
          num: { $sum: 1 },
          numRatings: { $sum: '$ratingsQuantity' },
          avgRating: { $avg: '$ratingsAverage' },
          avgPrice: { $avg: '$price' },
          minPrice: { $min: '$price' },
          maxPrice: { $max: '$price' },
        },
      },
      {
        $sort: { avgPrice: 1 },
      },
      // { $match: { _id: { $ne: 'EASY' } } },
    ]);

    res.status(200).json({
      status: 'sucess',
      results: stats.length,
      data: stats,
    });
  } catch (error) {
    console.log(error);
    res.status(404).json({
      status: 'fail',
      message: error,
    });
  }
};

Popularity 10/10 Helpfulness 3/10 Language javascript

Source: Grepper

Tags: aggregate express javascript mongoose node.js

Link to this answer
Share Copy Link

Contributed on Oct 16 2022

Shirshak Kandel

0 Answers Avg Quality 2/10

Closely Related Answers

aggregate mongoose example

Comment

let videos= await Beg.aggregate([
        {
          $project: { // allows you to select or unselect filed.
            _id: 1,//_id: 1 will select the field and _id: 0 will unselect field 
          },
        },
        {
          $lookup: {
            from: "videos", //the sub table or document
            localField: "_id", // filed name of main table or doc
            foreignField: "begId", // filed name of sub table or doc
            as: "videos", // name your object
          },
        },
      ]);

Popularity 10/10 Helpfulness 2/10 Language whatever

Source: Grepper

Tags: aggregate aggr

Link to this answer
Share Copy Link

Contributed on Jan 27 2023

Dhaval Italiya

0 Answers Avg Quality 2/10

how to use mongoose aggregate

Comment

-2

const agg = Model.aggregate([{ $match: { age: { $gte: 25 } } }]);
for await (const doc of agg) {
  console.log(doc.name);
}

Popularity 10/10 Helpfulness 1/10 Language whatever

Source: mongoosejs.com

Tags: aggregate aggr

Link to this answer
Share Copy Link

Contributed on Nov 10 2020

Bad Bird

0 Answers Avg Quality 2/10

aggregate in mongoose express node.js

Contents

More Related Answers

aggregate in mongoose express node.js

Closely Related Answers

aggregate mongoose example

how to use mongoose aggregate

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.