Description

'ifNull' operator in aggregate is giving us two outcomes for a boolean sub value. Our query works for a sub object key which may not exist or may have a Boolean value.

When the key does not exist the project pipeline works fine ,but when the key has a Boolean value we get two different outcomes.

For a false value the query assigns a value which is different when the value is true based on what we give in the project if else condition.

We were expecting it would give the same value be it true or false.

Scope of changes

Impact to Other Docs

MVP (Work and Date)

Resources (Scope or Design Docs, Invision, etc.)