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

Support - Assistance technique
1

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

2

Adding Juan and Jose, who has dealt with similar situations.

···

Rodolfo Meliá

*Principal | *rmelia@knowming.com

Skype: rod.melia | +44 777 576 4090 | +1 708 872 7636

www.knowming.com

On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT ptb3000@gmail.com 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

–

3

Adding Juan and Jose, who has dealt with similar situations.

···

On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT ptb3000@gmail.com 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

–

4

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@knowming.com wrote:

Adding Juan and Jose, who has dealt with similar situations.

On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT ptb3000@gmail.com 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

–

5

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@gmail.com 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

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

On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia rmelia@knowming.com wrote:

Adding Juan and Jose, who has dealt with similar situations.

On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT ptb3000@gmail.com 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

–

6

Hi Prosper,

**[DE:1.2.3] is null **works fine.

···

On Sat, Oct 11, 2014 at 8:24 PM, Prosper BT ptb3000@gmail.com 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@gmail.com 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

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

On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia rmelia@knowming.com wrote:

Adding Juan and Jose, who has dealt with similar situations.

On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT ptb3000@gmail.com 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

–

7

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

Inline image 1

null failed to run.pdf (116 KB)

···

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

Hi Prosper,

**[DE:1.2.3] is null **works fine.

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

On Sat, Oct 11, 2014 at 8:24 PM, Prosper BT ptb3000@gmail.com 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@gmail.com 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

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

On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia rmelia@knowming.com wrote:

Adding Juan and Jose, who has dealt with similar situations.

On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT ptb3000@gmail.com 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

–

8

Thanks for the snapshot, Prosper.

I saw the bug now. I am working on it. Will inform you when I finish.

image

···

On Sat, Oct 11, 2014 at 8:59 PM, Prosper BT ptb3000@gmail.com 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

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

Hi Prosper,

**[DE:1.2.3] is null **works fine.

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

On Sat, Oct 11, 2014 at 8:24 PM, Prosper BT ptb3000@gmail.com 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@gmail.com 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

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

On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia rmelia@knowming.com wrote:

Adding Juan and Jose, who has dealt with similar situations.

On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT ptb3000@gmail.com 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

–

9

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

image

···

On Sat, Oct 11, 2014 at 9:12 PM, Tran Chau (HISP Vietnam) tran.hispvietnam@gmail.com 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@gmail.com 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

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

Hi Prosper,

**[DE:1.2.3] is null **works fine.

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

On Sat, Oct 11, 2014 at 8:24 PM, Prosper BT ptb3000@gmail.com 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@gmail.com 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

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

On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia rmelia@knowming.com wrote:

Adding Juan and Jose, who has dealt with similar situations.

On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT ptb3000@gmail.com 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

–

10

Thanks - we updated the servers yesterday night, so the fix should be deployed.

image

···

Rodolfo Meliá

*Principal | *rmelia@knowming.com

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@gmail.com 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@gmail.com 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@gmail.com 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

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

Hi Prosper,

**[DE:1.2.3] is null **works fine.

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

On Sat, Oct 11, 2014 at 8:24 PM, Prosper BT ptb3000@gmail.com 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@gmail.com 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

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

On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia rmelia@knowming.com wrote:

Adding Juan and Jose, who has dealt with similar situations.

On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT ptb3000@gmail.com 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

–

11

Thanks Tran,

We have tested and ‘is null’ is working now,

Regards

image

···

On Tue, Oct 14, 2014 at 2:58 PM, Rodolfo Melia rmelia@knowming.com wrote:

Thanks - we updated the servers yesterday night, so the fix should be deployed.

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

Rodolfo Meliá

*Principal | *rmelia@knowming.com

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@gmail.com 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@gmail.com 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@gmail.com 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

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

Hi Prosper,

**[DE:1.2.3] is null **works fine.

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

On Sat, Oct 11, 2014 at 8:24 PM, Prosper BT ptb3000@gmail.com 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@gmail.com 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

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

On Sat, Oct 11, 2014 at 5:06 PM, Rodolfo Melia rmelia@knowming.com wrote:

Adding Juan and Jose, who has dealt with similar situations.

On Fri, Oct 10, 2014 at 7:10 PM, Prosper BT ptb3000@gmail.com 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

–