Aggregation query builder

Support - Assistance technique
1

Hi DHIS2 family,
Do you know Aggregation query builder has if-condition?

Thanks

CHANNARA

2

Hi Channara,

Aggregation query builder doesn’t have if-condition

Tran Chau

···

On Mar 2, 2015 4:30 PM, “channara rin” rin.channara@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

3

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,

···

On Mon, Mar 2, 2015 at 2:02 PM, Chau Thu Tran cthutran@gmail.com wrote:

Hi Channara,

Aggregation query builder doesn’t have if-condition

Tran Chau

On Mar 2, 2015 4:30 PM, “channara rin” rin.channara@gmail.com 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@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-devs

More help : https://help.launchpad.net/ListHelp

Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Sam Kasozi
Information Systems Consultant
HISP Uganda | GHSI - Uganda MOH - PH Emergency Operation Center
+256 788 993565 | +256 757 662752

kasozis@gmail.com | skasozi@pheoc.go.ug | Skype: sam.kasoziug