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

aggregate mongodb

Add Answer

Abhishek answered on October 14, 2021 Popularity 10/10 Helpfulness 3/10

answer aggregate mongodb

related mongodb aggregate project

related mongodb aggregate cond $in

aggregate mongodb

Comment

// MonogDB Aggregation Framework
// $project -> $match -> $group -> $sort -> ouput
// $count, $skip, Sunwind,
// $match
db.users.aggregate([
{ stage 1}, $project
 { stage 2}, $match
  { stage 3}, $group
   { stage 4}, $sort
]);

* match : 
db.users.aggregate([{$match:{'status':'inactive'}}]).pretty();

* group :
// group by department 
db.users.aggregate([{$group:{_id:'$department'}}]).pretty();
{"id" : "IT" } {
{"_id" : "TECH" }
{_"id" : "HR" }

- multiple group 
db.users.aggregate([{$group:{_id:{age:'Şage',gender:'$gender'}}}]).pretty();

{"id" : { "age" : "27", 'gender' : "female" }}
{"_id" : { "age" : "25", "gender" : "female" } }
{ "_id" : { "age" : "26" "gender" : "male" } }
{ "_id" : { "age" : "24", "gender" : "male" } }
{ "_id" : { "age" : "22", "gender" : "male" } }
{"_id" : { "age" : "27", "gender" : "male" } }

* sort 
db.users.aggregate([{$group:{_id:'$department'}},{$sort:{_id:1}}]);

* match 
db.users.aggregate([{$match:{status:'active'}},{$project:{name:1,email:1}}]).pretty();

* count 
db.users.aggregate([{$match:{status:'inactive'}},{$count:'totals'}]);

* limit 
db.users.aggregate([{$match:{status:'active'}},{$project:{name:1,email:1}},{Slimit:2}]).pretty();

* unwind 
- It is used for array attribute to show seprate result for that array.

db.users.aggregate([{$unwind:"$language"},{$match:{status:'inactive'}},{$project:{name:1,language:1}}]).pretty();
db.users.aggregate([{$unwind:'$language'},{$group:{_td:'$language'}}]);

* lookup
- Joining two tables
 
db.users.aggregate({
    $lookup:{
        from: "department",
        localField:"dept", 06
        foreignField: "name"
        as: "anything"
})

* out 
- It will create the new collection with that name and storing the data result into it. 
db.users.aggregate([{ $match:{status:'active'}},{$project:{email:1,name:1, id:0}},{'$out':'info'}]).pretty();

Popularity 10/10 Helpfulness 3/10 Language javascript

Source: Grepper

Tags: aggregate javascript mongodb

Link to this answer
Share Copy Link

Contributed on Apr 16 2022

Abhishek

0 Answers Avg Quality 2/10

Closely Related Answers

mongodb aggregate project

Comment

db.books.aggregate( [ { $project : { title : 1 , author : 1 } } ] )

Popularity 10/10 Helpfulness 3/10 Language javascript

Source: Grepper

Tags: aggregate aggr

Link to this answer
Share Copy Link

Contributed on Feb 23 2022

florinrelea

0 Answers Avg Quality 2/10

mongodb aggregate cond $in

Comment

cond: {
  $and: [{
  	$in: ['$$viewsDoc.year', [1, 2, 3]]
  }]
}

Popularity 10/10 Helpfulness 2/10 Language typescript

Source: Grepper

Tags: aggregate aggr

Link to this answer
Share Copy Link

Contributed on Oct 14 2021

florinrelea

0 Answers Avg Quality 2/10

aggregate mongodb

Contents

More Related Answers

aggregate mongodb

Closely Related Answers

mongodb aggregate project

mongodb aggregate cond $in

Grepper

Documentation

Social

Legal

Contact

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