Re: [Dhis2-users] Aggregation query builder details

2016-01-05 Thread Ese Egerega
aimer>. Please read the >> disclaimer before opening any attachment or taking any other action in >> terms of this electronic transmission. >> If you cannot access the disclaimer, kindly send an email to >> disclai...@hisp.org and a copy will be provided to >> you.

Re: [Dhis2-users] Aggregation query builder details

2015-11-27 Thread Olav Poppe
>> If you cannot access the disclaimer, kindly send an email to >> disclai...@hisp.org and a copy will be provided to you. By replying to this >> e-mail or opening any attachment you agree to be bound by the provisions of >> the disclaimer. >> >> >> >

Re: [Dhis2-users] Aggregation query builder details

2015-11-26 Thread Knut Staring
a copy will be provided to you. By replying to this e-mail or opening > any attachment you agree to be bound by the provisions of the disclaimer. > > > > *From:* Dhis2-users [mailto:dhis2-users-bounces+elmarie= > hisp@lists.launchpad.net] *On Behalf Of *Dipali Sahu > *Sent

Re: [Dhis2-users] Aggregation query builder details

2015-11-26 Thread Elmarie Claasen
o be bound by the provisions of the disclaimer. From: Dhis2-users [mailto:dhis2-users-bounces+elmarie=hisp@lists.launchpad.net] On Behalf Of Dipali Sahu Sent: 26 November 2015 12:49 PM To: Knut Staring Cc: DHIS 2 Users list Subject: Re: [Dhis2-users] Aggregation query builder details

Re: [Dhis2-users] Aggregation query builder details

2015-11-26 Thread Dipali Sahu
Hi Knut We actually use Aggregation query builder to a large extent to get aggregated data. Exclusively, all our data is captured through Event capture, and we aggregate it through Aggregation query builder, so that the aggregated values can be shown in datasets as well as Pivot tables. Also, usin

Re: [Dhis2-users] Aggregation query builder details

2015-11-25 Thread Nami Ghadri
: [Dhis2-users] Aggregation query builder details Hi Nami, Which version of DHIS2 are you working on? We are phasing out the aggregation query builder in favor of program indicators. Knut On Tue, Nov 24, 2015 at 5:45 PM, Nami Ghadri mailto:nami_gha...@hotmail.com> > wrote:

Re: [Dhis2-users] Aggregation query builder details

2015-11-25 Thread Knut Staring
Hi Nami, Which version of DHIS2 are you working on? We are phasing out the aggregation query builder in favor of program indicators. Knut On Tue, Nov 24, 2015 at 5:45 PM, Nami Ghadri wrote: > Hello, > > > > I want to create an Aggregation query builder details as sum of data > element value I

[Dhis2-users] Aggregation query builder details

2015-11-24 Thread Nami Ghadri
Hello, I want to create an Aggregation query builder details as sum of data element value I put everything but it comes to Data element for sum/average/min/max * and try to select I can't find anything and this field is mandatory and the data aggregator data element and tracker data elemen

[Dhis2-users] Aggregation query builder

2015-03-02 Thread channara rin
Hi DHIS2 family, Do you know Aggregation query builder has if-condition? Thanks CHANNARA ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-users More help : htt

Re: [Dhis2-users] Aggregation query builder

2015-02-23 Thread channara rin
seem another data element is OK, but why only that data element meet error? s.th wrong with it? any one tell me? Thank you Channara On Mon, Feb 23, 2015 at 4:53 PM, channara rin wrote: > I did like that, but wonder has error. Let me try another data element > first, i will inform you soon... >

Re: [Dhis2-users] Aggregation query builder

2015-02-23 Thread channara rin
I did like that, but wonder has error. Let me try another data element first, i will inform you soon... Thank you Channara On Mon, Feb 23, 2015 at 4:48 PM, Emma Kassy wrote: > Hi Channara, > The data element should be assigned to a different data set. > In other wards, you can have the same dat

Re: [Dhis2-users] Aggregation query builder

2015-02-23 Thread Emma Kassy
Hi Channara, The data element should be assigned to a different data set. In other wards, you can have the same data element but in different data sets. That way you will not have an error. On Mon, Feb 23, 2015 at 8:13 AM, channara rin wrote: > Hi all DHIS2, > I wonder can i make aggregation que

[Dhis2-users] Aggregation query builder

2015-02-22 Thread channara rin
Hi all DHIS2, I wonder can i make aggregation query builder for the same data element but in different organisation unit? When i did, i go the error? [image: Inline image 1] ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@l

[Dhis2-users] Aggregation query builder Edite

2015-01-23 Thread Nami Ghadri
Hello, I have a problem Whenever I want to edit exiting aggregation query builder it gave me white web page and do nothing Like the printed screen shoot in bellow Any advice please thanks ___ Mailing list: https://launchpad.ne

[Dhis2-users] Aggregation query builder management

2014-12-30 Thread Nami Ghadri
Hello, Whenever I try to edit query in Aggregation query builder management the webpage do show any thing Any advice or ideas Thanks ___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsu

[Dhis2-users] Aggregation Query Builder

2014-08-18 Thread rin.channara
Hi all, DO you have any guide to use aggregation query builder with DateDiff. I tried with demo, it doesn't success. Thank you CHANNARA___ Mailing list: https://launchpad.net/~dhis2-users Post to : dhis2-users@lists.launchpad.net Unsubscribe : ht

Re: [Dhis2-users] Aggregation Query Builder problem

2014-03-30 Thread sumudu weerasinghe
Yes i think it is not working in PostgreSQL. On Sat, Mar 29, 2014 at 10:27 PM, Manaf Abthul wrote: > Hi sumudu, > > It is working, testing is successful on Version:2.14 Build revision:13826. > > I have checked for number of Asthma patient less than 12yrs. The age > attribute is patient attribut

Re: [Dhis2-users] Aggregation Query Builder Problem

2014-03-23 Thread Bram Piot
Hi, I've noticed this bug too, but it only seems to happen when one first filters on the data elements. Manaf, can you try selecting your data element without first filtering on the name, and see if that works? bram On Mar 24, 2014 5:44 AM, "Tran Chau" wrote: > Hi Manaf, > > This bug doesn't o

Re: [Dhis2-users] Aggregation Query Builder Problem

2014-03-23 Thread Tran Chau
Hi Manaf, This bug doesn't occur in my side. Could you please create an example on demo server ? Then we can look at it and test. Thank you. Best regards, Châu Thu Trân HISP Viet Nam Email: tran.hispviet...@gmail.com On Mon, Mar 24, 2014 at 3:54

Re: [Dhis2-users] Aggregation Query Builder doesn't count

2013-09-02 Thread Tran Chau
dhis2-users@lists.launchpad.net > From: tran.hispviet...@gmail.com > > Subject: Re: [Dhis2-users] Aggregation Query Builder doesn't count > Date: Sat, 31 Aug 2013 10:14:28 +0700 > To: helder_...@hotmail.com > > > Hi Helder, > > This bug was fixed for only 1.12 version.

Re: [Dhis2-users] Aggregation Query Builder doesn't count

2013-09-02 Thread helder yesid castrillon cobo
...@gmail.com Subject: Re: [Dhis2-users] Aggregation Query Builder doesn't count Date: Sat, 31 Aug 2013 10:14:28 +0700 To: helder_...@hotmail.com Hi Helder, This bug was fixed for only 1.12 version. For 2.13, we have a plan to improve it by using web-API. And I am working on it. I tested this b

Re: [Dhis2-users] Aggregation Query Builder doesn't count

2013-08-30 Thread Tran Chau
. Mg. Helder Yesid Castrillon. Sistemas de información Secretaría departamental de salud del cauca. From: helder_...@hotmail.com To: tran.hispviet...@gmail.com Date: Fri, 30 Aug 2013 15:17:29 +0200 CC: dhis2-users@lists.launchpad.net Subject: Re: [Dhis2-users] Aggregation Query Builder doesn't

Re: [Dhis2-users] Aggregation Query Builder doesn't count

2013-08-26 Thread Tran Chau
-users@lists.launchpad.net > Date: Tue, 27 Aug 2013 00:43:56 +0200 > Subject: Re: [Dhis2-users] Aggregation Query Builder doesn't count > > > Hi, We have reviewed in detail and we found that the problem is presented > with aggregation query that use the attribute of patient th

Re: [Dhis2-users] Aggregation Query Builder doesn't count

2013-08-26 Thread helder yesid castrillon cobo
sorry!! SEX = gender In spanish genero, sexo. ING. Helder Yesid Castrillon. From: helder_...@hotmail.com To: markodavi...@gmail.com; dhis2-users@lists.launchpad.net Date: Tue, 27 Aug 2013 00:43:56 +0200 Subject: Re: [Dhis2-users] Aggregation Query Builder doesn't count Hi, We

Re: [Dhis2-users] Aggregation Query Builder doesn't count

2013-08-26 Thread helder yesid castrillon cobo
Thanks, ING. Helder Yesid Castrillon. Secretaría departamental de salud Date: Mon, 26 Aug 2013 09:21:39 -0500 From: markodavi...@gmail.com To: dhis2-users@lists.launchpad.net Subject: [Dhis2-users] Aggregation Query Builder doesn't count Hello Friends. After migrate to 2.12 version, the

[Dhis2-users] Aggregation Query Builder doesn't count

2013-08-26 Thread Marko David Garcia
Hello Friends. After migrate to 2.12 version, the aggregation query builder doesn't aggregate the values in the data element. We test with new data elements, simple queries but doesn't work. Maybe the new version has other parameters to aggregate the values?. Thank you very much. -- Regards

Re: [Dhis2-users] Aggregation Query Builder: Syntax error?

2012-12-21 Thread Marta Vila
Thanks Trân! it is working fine now. On 21 December 2012 12:54, Tran Chau wrote: > *( [CP:gender]='F' AND ( [DE:2528.2529.2524]='210 - Dengue' ) OR ( > **[CP:gender]='F' > AND **[DE:2528.2529.2524]='220 - Dengue grave' )* ___ Mailing list: https://

Re: [Dhis2-users] Aggregation Query Builder: Syntax error?

2012-12-21 Thread Tran Chau
Dear Marta, Please modify the formulas as follows: *( [CP:gender]='M' AND [DE:2528.2529.2524]='210 - Dengue' ) OR (** [CP:gender]='M' AND **[DE:2528.2529.2524]='220 - Dengue grave' ) * * * *( [CP:gender]='F' AND ( [DE:2528.2529.2524]='210 - Dengue' ) OR ( **[CP:gender]='F' AND **[DE:2528.2529

[Dhis2-users] Aggregation Query Builder: Syntax error?

2012-12-21 Thread Marta Vila
Dear all, i´m aggregating cases by diagnosis and gender. The query condition looks like this: *[CP:gender]='M' AND ( [DE:2528.2529.2524]='210 - Dengue' OR [DE:2528.2529.2524]='220 - Dengue grave' ) * * * *[CP:gender]='F' AND ( [DE:2528.2529.2524]='210 - Dengue' OR [DE:2528.2529.2524]='220 - Den