dhis2-devs team mailing list archive

[Alex Tumwesigye <atumwesigye@xxxxxxxxx>]

Dear Olav,

Good. Let me know if it works.

Alex

On Fri, Jul 8, 2016 at 2:47 PM, Olav Poppe <olav.poppe@xxxxxx> wrote:

> BTW, I see now that my initial formula was completely messed up, but the
> bug is still there…
>
> Olav
>
>
>
>
> 8. jul. 2016 kl. 13.43 skrev Olav Poppe <olav.poppe@xxxxxx>:
>
> Thanks Alex, after a bit more digging I think I’ve identified a bug in
> d2:condition which might be causing this by messing up the quotes in the
> SQL that is generated (I might still need the brackets though):
>
> This simple d2:condition():
> d2:condition(#{wmSb9TmevMn.FlzVuMSdC2F} == 'MONTHS', true, false)
>
> Is translated into this SQL:
> select count(distinct psi) as value,"yearly" from
> analytics_event_2016_jo4aktbheqq where Yearly in ('2016') and (uidlevel1 =
> 'M4nRM5O3mH8' ) and (case when *(FlzVuMSdC2F" = 'MONTHS)* then true else
> false end) group by "yearly" limit 200001
>
> Which
> 1) is missing a " before FlzVuMSdC2F, AND
> 2) has stripped off the ‘ after MONTHS
>
> I’ll report it as a bug.
>
> Regards
> Olav
>
>
>
>
>
>
>
>
> 8. jul. 2016 kl. 13.07 skrev Alex Tumwesigye <atumwesigye@xxxxxxxxx>:
>
> Olav,
>
> I have not tried it, how about using brackets? e.g
> d2:condition(x1,(d2:condition(x2,(d2:condition(x3,x3true,x3false),x2false),x1false)
>
> I am not sure if the brackets are supported but it will keep it in the
> same format.
>
> Alex
>
> On Fri, Jul 8, 2016 at 1:55 PM, Olav Poppe <olav.poppe@xxxxxx> wrote:
>
>> Hi devs,
>> I’m trying to set up a program indicator that counts events within age
>> groups. Age is collected with two different methods:
>> - Date of birth and date of death
>> - Estimated age (when DoB is not available), using one «periodtype» field
>> and one «period count» field, e.g. 4 and Months in two different data
>> elements.
>>
>> Based on this, I wanted to calculated a few indicators, including «age in
>> years» for individual events, and counting number of events by age groups
>> (0-4 years etc). I figured I could do this by having multiple
>> d2:condition() functions (see below), but that gives «Illegal arguments,
>> expected 3 arguments: condition, true-value, false-value». Can someone
>> confirm whether or not nesting d2:condition() is supported or not, and
>> advice on alternative approaches?
>>
>> Regards
>> Olav
>>
>>
>> d2:condition(#{wmSb9TmevMn.UoL9vGPT0qF} is not null,
>>     d2:daysBetween(#{wmSb9TmevMn.UoL9vGPT0qF},V{execution_date}) < 1825,
>>     d2:condition(#{wmSb9TmevMn.FlzVuMSdC2F} == 'YEARS',
>>         #{wmSb9TmevMn.Zp1elSUYpwI} < 5,
>>         d2:condition(#{wmSb9TmevMn.FlzVuMSdC2F} == 'MONTHS',
>>             #{wmSb9TmevMn.Zp1elSUYpwI} < 60
>>             d2:condition(#{wmSb9TmevMn.FlzVuMSdC2F} == 'WEEKS',
>>                  #{wmSb9TmevMn.Zp1elSUYpwI} < 260,
>>                      d2:condition(#{wmSb9TmevMn.FlzVuMSdC2F} == 'DAYS',
>>                      #{wmSb9TmevMn.Zp1elSUYpwI} < 1825,
>>                          d2:condition(#{wmSb9TmevMn.FlzVuMSdC2F} ==
>> 'DAYS',
>>                          #{wmSb9TmevMn.Zp1elSUYpwI} < 43800,
>>                          false)
>>                      )
>>               )
>>          )
>>     )
>> )
>>
>>
>> _______________________________________________
>> Mailing list: https://launchpad.net/~dhis2-devs
>> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
>> Unsubscribe : https://launchpad.net/~dhis2-devs
>> More help   : https://help.launchpad.net/ListHelp
>>
>>
>
>
> --
> Alex Tumwesigye
>
> Technical Advisor - DHIS2 (Consultant),
> Ministry of Health/AFENET  | HISP Uganda
> Kampala
> Uganda
> +256 774149 775, + 256 759 800161
> Skype ID: talexie
>
> IT Consultant (Servers, Networks and Security, Health Information Systems
> - DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant
>
>
> "I don't want to be anything other than what I have been - one tree hill "
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-devs
> Post to     : dhis2-devs@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-devs
> More help   : https://help.launchpad.net/ListHelp
>
>
>


-- 
Alex Tumwesigye

Technical Advisor - DHIS2 (Consultant),
Ministry of Health/AFENET  | HISP Uganda
Kampala
Uganda
+256 774149 775, + 256 759 800161
Skype ID: talexie

IT Consultant (Servers, Networks and Security, Health Information Systems -
DHIS2, Disease Outbreak & Surveillance Systems) & Solar Consultant


"I don't want to be anything other than what I have been - one tree hill "