Aggregate returning wrong results

Hi all.

I noticed that this kind of filters seem not to work inside an aggregate. Has anyone experienced this issue? Why doesn't detect that is the same value?



Thanks in advance.

What is the error?

Filipa Rebelo wrote:

Hi all.

I noticed that this kind of filters seem not to work inside an aggregate. Has anyone experienced this issue? Why doesn't detect that is the same value?



Thanks in advance.

Hi FIlipa,


PLease elaborate problem this image show only filter condition. and filter condition is right so decribe what paratemer you pass and what value you get.


Kind Regard

Rahul


The problem is that this query doens't return any results, but if I remove the condition in red the aggregate gives results. 

Solution

IN SQL, if the parent code is NULL, 

NULL = NULL is evaluated to false

Solution

brrr wrote:

IN SQL, if the parent code is NULL, 

NULL = NULL is evaluated to false


Ah ok, good to know. I think that can be the case. Thanks!