← Back to team overview

dhis2-devs team mailing list archive

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

 

Thanks Tran,

We have tested and 'is null' is working now,

Regards

On Tue, Oct 14, 2014 at 2:58 PM, Rodolfo Melia <rmelia@xxxxxxxxxxxx> wrote:

> Thanks - we updated the servers yesterday night, so the fix should be
> deployed.
>
> *Rodolfo Meliá*
> *Principal  |  *rmelia@xxxxxxxxxxxx
> Skype: rod.melia  |  +44 777 576 4090  |  +1 708 872 7636
> www.knowming.com
>
> On Sat, Oct 11, 2014 at 4:01 PM, Tran Chau (HISP Vietnam) <
> tran.hispvietnam@xxxxxxxxx> wrote:
>
>> Hi Prosper,
>>
>> It is fixed on trunk with revision 17060 and 2.16 version with revision
>> 16512.
>>
>> Please update your code and take a look at it.
>> Thank you.
>>
>> ....................
>>
>> Best regards,
>> Tran
>>
>> On Sat, Oct 11, 2014 at 9:12 PM, Tran Chau (HISP Vietnam) <
>> tran.hispvietnam@xxxxxxxxx> wrote:
>>
>>> Thanks for the snapshot, Prosper.
>>>
>>> I saw the bug now. I am working on it. Will inform you when I finish.
>>>
>>> On Sat, Oct 11, 2014 at 8:59 PM, Prosper BT <ptb3000@xxxxxxxxx> wrote:
>>>
>>>> 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
>>>>
>>>>
>>>
>>>
>>
>


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

PNG image


References