Unable to use aggregate function in MongoDB

Question

Is it possible to use aggregate function after the find function in MongoDB? I want to query a document and then aggregate according to find result.

db.movies.find({"runtime":30},{runtime:1,year:1,"imdb.rating":1,"imdb.votes":1,type:1,"tomatoes.viewer.rating":1,"awards.wins":1}).limit(3).aggregate([{$group:{_id:"$runtime",award_wins:{$sum:1}}}])

After executing this command I am getting an error that, aggregate is not a function,

E QUERY [js] TypeError: db.movies.find(...).limit(...).aggregate is not a function :

sushant mehta · Accepted Answer · 2019-08-30 06:04:46Z

1

Run it as below,you can't run aggregate along/after find

db.movies.aggregate([
{$match:{"runtime":30}},
{$project{runtime:1,year:1,"imdb.rating":1,"imdb.votes":1,type:1,"tomatoes.viewer.rating":1,"awards.wins":1}},
{$limit:3},
{$group:{_id:"$runtime",award_wins:{$sum:1}}}
])

answered Aug 30, 2019 at 6:04

sushant mehta

1,2841 gold badge7 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

sushant mehta Over a year ago

Do upvote and mark as answer if the answer was helpful.

Dexter · Accepted Answer · 2019-08-30 06:05:45Z

1

To invoke the aggregate function, you must use db..aggregate instead of find. Try the below:

db.movies.aggregate({"runtime":30},{runtime:1,year:1,"imdb.rating":1,"imdb.votes":1,type:1,"tomatoes.viewer.rating":1,"awards.wins":1}).limit(3).aggregate([{$group:{_id:"$runtime",award_wins:{$sum:1}}}])

answered Aug 30, 2019 at 6:05

Dexter

9928 silver badges20 bronze badges

Comments

Anitta Paul · Accepted Answer · 2019-08-30 06:12:57Z

1

aggregate() cannot be used along with find(). You should use corresponding aggregate methods to execute the query.

Edit: Try this out.

db.movies.aggregate([
{$match:{"runtime":30}},
{$project:{runtime:1,year:1,"imdb.rating":1,"imdb.votes":1,type:1,"tomatoes.viewer.rating":1,"awards.wins":1}},
{$limit:3},
{$group:{_id:"$runtime",award_wins:{$sum:1}}}
])

edited Aug 30, 2019 at 6:12

answered Aug 30, 2019 at 6:02

Anitta Paul

4756 silver badges18 bronze badges

1 Comment

Atul Tiwari Over a year ago

Can you please explain a little more with an example?

Collectives™ on Stack Overflow

Unable to use aggregate function in MongoDB

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related