dhis2-users team mailing list archive
-
dhis2-users team
-
Mailing list archive
-
Message #06448
Re: [Dhis2-devs] Aggregation query builder
Hi Channara,
While it might not have an explicit 'IF', with the help of: 'AND', 'OR',
'==NULL', '!=NULL' and other logical operators, most if not all scenarios
of the IF - Condition can be evaluated especially since the goal is to
aggregate a value only if a specific condition holds.
i.e if( *Registration !=NULL*) THEN ... Aggregate
The same condition in RED is what would go in the condition text area. If
it is a nested IF(one inside the other) , then combining the different
conditions with AND will yield the same effect.
regards,
Sam Kasozi
Information Systems Consultant
HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
+256 788 993565 | +256 757 662752
kasozis@xxxxxxxxx | skasozi@xxxxxxxxxxx <kasozis@xxxxxxxxx> | Skype:
sam.kasoziug
On Mon, Mar 2, 2015 at 2:02 PM, Chau Thu Tran <cthutran@xxxxxxxxx> wrote:
> Hi Channara,
>
> Aggregation query builder doesn't have if-condition
>
> Tran Chau
> On Mar 2, 2015 4:30 PM, "channara rin" <rin.channara@xxxxxxxxx> wrote:
>
>> Hi DHIS2 family,
>> Do you know Aggregation query builder has if-condition?
>>
>> Thanks
>> CHANNARA
>>
>> _______________________________________________
>> 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
>>
>>
> _______________________________________________
> Mailing list: https://launchpad.net/~dhis2-users
> Post to : dhis2-users@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~dhis2-users
> More help : https://help.launchpad.net/ListHelp
>
>
References