Aggregation Expression
noun
say it: “ag-rih-GAY-shun ik-SPRESH-un” /ˌæɡrɪˈɡeɪʃən ɪkˈsprɛʃən/
In a MongoDB pipeline, a small formula, such as $multiply or $round, worked out for each document.
What is an aggregation expression?
An aggregation expression is a small formula a stage works out for each document, written as an operator with its inputs, such as { $multiply: ["$price", "$qty"] }. Expressions can go inside each other, such as $round around a $multiply.
db.orderItems.aggregate([
{ $set: { lineTotal: { $round: [{ $multiply: ["$price", "$qty"] }, 2] } } }
]);
// { item: 'Bell', price: 12.49, qty: 3, lineTotal: 37.47, ... }
In a sentence
- “Wrapping one aggregation expression in another, $round kept the totals to two decimal places.”
- “The aggregation expression $multiply worked out each line's price times its quantity.”
Level: Journeyman · More MongoDB terms at this level
Updated