I'm using an aggregate and I'd like to add a Boolean property per Document for if all properties in a subArray on the Document are true.
In my example below...CONFLICTS is a subArray of Docs that each contain a Boolean property called Resolved. I just want to add a new allResolved field for if all Conflicts are resolved.
So..in my addFields stage, I have something like
{
'$project': {
'allResolved': {
'$allElementsTrue': '$CONFLICTS.resolved'
},
}
}
so JS equivalent is const allResolved = CONFLICTS.every(conflict => conflict.resolved)
But this seems to always return true which is not correct
Query
aggregate(
[{"$set":
{"allResolved":
{"$and":
[{"$isArray":["$conflicts"]},
{"$not":[{"$eq":["$conflicts", []]}]},
{"$reduce":
{"input":"$conflicts",
"initialValue":true,
"in":
{"$and":[{"$eq":["$$this.Resolved", true]}, "$$value"]}}}]}}}])