← Back to team overview

dhis2-devs team mailing list archive

Re: Bug when using ==NULL (is null ) in aggregate query builder

 

Hi Tran,

Am running it both on the demo and dev servers, on testing the expressions
it fails see snap shot below and attached pdf

[image: Inline image 1]

On Sat, Oct 11, 2014 at 4:48 PM, Tran Chau (HISP Vietnam) <
tran.hispvietnam@xxxxxxxxx> wrote:

> Hi Prosper,
>
> *[DE:1.2.3] is null *works fine.
>
> On Sat, Oct 11, 2014 at 8:24 PM, Prosper BT <ptb3000@xxxxxxxxx> wrote:
>
>> Thanks Tran
>>
>> the one that doesnt work is *[DE:1.2.3] is null*
>>
>> On Sat, Oct 11, 2014 at 2:29 PM, Tran Chau (HISP Vietnam) <
>> tran.hispvietnam@xxxxxxxxx> wrote:
>>
>>> Hi all,
>>>
>>> This one *[DE:1.2.3] != null *doesn't work .
>>> Aggregate functionality works with formula  *[DE:1.2.3] is not null*.
>>>
>>> Best regard,
>>>
>>> Tran
>>>
>>> On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia <rmelia@xxxxxxxxxxxx>
>>> wrote:
>>>
>>>> Adding Juan and Jose, who has dealt with similar situations.
>>>>
>>>>>
>>>>>
>>>>> On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT <ptb3000@xxxxxxxxx> wrote:
>>>>>
>>>>>> Using 2.16 demo server, build not specified, there is an error when
>>>>>> dealing with data elements and trying to aggregate when data elements are
>>>>>> null.
>>>>>>
>>>>>> ([DE:2005727.*.2005735]  is null )
>>>>>>
>>>>>> Can you check it works for !=NULL
>>>>>>
>>>>>> Regards
>>>>>> --
>>>>>> Prosper Behumbiize, MPH
>>>>>> Phone:        +256 414 320076
>>>>>> Cell:             +256 772 139037
>>>>>>                      +256 752 751776
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>
>>
>>
>> --
>> Prosper Behumbiize, MPH
>> Phone:        +256 414 320076
>> Cell:             +256 772 139037
>>                      +256 752 751776
>>
>>
>
>


-- 
Prosper Behumbiize, MPH
Phone:        +256 414 320076
Cell:             +256 772 139037
                     +256 752 751776

PNG image

Attachment: null failed to run.pdf
Description: Adobe PDF document


Follow ups

References