Call function inside mongodb's aggregate?
External functions don't work with the aggregation framework. Everything is parsed to BSON on input, so no JavaScript or anything else is allowed. This is all basically processed from BSON "operator" definition to native C++ code implementation so it is really fast.
What this comes down to is "converting" your expected logic to what the aggregation framework can process. There are in fact "logical" operators such as $or
and $and
that work in this context:
db.collection.aggregate([
{ "$project": {
"_id": 1,
"status": {
"$cond": [
{ "$or": [
// Your first set of rules requires "false" for "flag1" or
// "flag2" and "true" for "flag3"
{ "$and": [
{ "$not": [
{ "$or": [ "$flag1", "$flag2" ] },
]},
"$flag3"
]},
// Your second set of rules requires "true" for "flag1" or
// "flag2" and "false" for "flag3"
{ "$and": [
{ "$or": [ "$flag1", "$flag2" ] },
{ "$not": [ "$flag3" ] }
]},
]},
"ok",
"broken"
]
}
}}
])
So no external functions, just implement the logic with the operators that the aggregation framework supplies. In addition to the basic logical implementations there is $not
to "reverse" the ligic and $cond
which acts as a "ternary" in order to provide a different result from true/false
evaluation.
The aggregate call can be passed a callback function, which is called after the aggregation has completed.
function getValuesAndMessges( params, callback ) {
db.collection.aggregate([
{ "$project": {
"_id": 1,
"flag1": { "$first": "$flag1" },
"flag2": { "$first": "$flag2" },
"flag3": { "$first": "$flag3" },
}}
], function( err, results ) {
if ( !err ) {
result.forEach( result => {
// process items in results here, setting a value
// using the actual logic for writing message ...
if( flag1 )
result.message = "broken";
else
result.messsge = 'OK';
});
}
callback(err, results);
});
}
this way each of your aggregated items (based on your conditions / parameters) will have a message property (or whatever properties you choose to write) set and you can use them in your calling function.