[DOCS-13498] $ifNull not working as expected Created: 09/Mar/20  Updated: 30/Oct/23

Status: Closed
Project: Documentation
Component/s: manual
Affects Version/s: 3.6.6
Fix Version/s: Server_Docs_20231030

Type: Bug Priority: Major - P3
Reporter: Clifford Pereira Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: Bug
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Development


Participants:
Days since reply: 1 year, 14 weeks, 2 days ago
Epic Link: DOCSP-1769

 Description   

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.)



 Comments   
Comment by Education Bot [ 31/Oct/22 ]

Hello! This ticket has been closed due to inactivity. If you believe this ticket is still important, please reopen it and leave a comment to explain why. Thank you!

Comment by Clifford Pereira [ 18/Mar/20 ]

Any updates on this?

Generated at Thu Feb 08 08:07:57 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.