Open
Description
I would love to be able to compare fields with each other in a query without needing to fall back on javascript in the where operator.
Since MongoDB 3.6+ we can use expressions within queries: https://docs.mongodb.com/v3.6/reference/operator/query/expr/
Example: db.monthlyBudget.find( { $expr: { $gt: [ "$spent" , "$budget" ] } } )
Using $expr instead of javascript would obviously perform better.
Is this planned for a future release?
Thanx!
Chris