can we use $gte operator in $project phase using aggregations in MongoDB

Question

Here i want to get AC3 phones list whose price is greater than 200 using aggregation

db.Products.aggregate([{$match:{name:"AC3 Phone"}},{$project:{_id:0,cost:{$price:{$gte:200}}}}]

when i executed above command in mongo shell,this is the error i got

"ok" : 0,
"errmsg" : "Unrecognized expression '$price'",
"code" : 168,
"codeName" : "InvalidPipelineOperator"

My doubt is that can we use $gte operator in projection phase using aggregations in MongoDB as mentioned in above

Not clear what you are asking for here. Are you expecting to return A. Return only phones where the price is greater than 200 B. Return ALL phones but indicate if the price is greater than 200 or not. Which one sounds like what you want? A or B — Neil Lunn
– Neil Lunn, Commented May 2, 2018 at 5:43

Devendra Singh · Accepted Answer · 2018-05-02 04:48:05Z

0

No, You can not use $gte (aggregation operators) with $project, you should check the condition with $match operator.

for further information regarding the aggregation, you can read this link

you can also go through with this answer for your clarification.

answered May 2, 2018 at 4:48

Devendra Singh

6401 gold badge6 silver badges12 bronze badges

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

1 Answer 1