Aggregation Query Builder doesn't count

Marko_David_Garcia · 26 August 2013 14:21

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,

Ing. Marko David Garcia M.
**Área de Sistemas integrados de Información
Secretaría de Salud Departamental del Cauca
**

helder_yesid_castril · 26 August 2013 22:43

Hi, We have reviewed in detail and we found that the problem is presented with aggregation query that use the attribute of patient that we have created.
The postgres console print the next error.

ERROR: syntax error at or near ")" at character 617
STATEMENT: SELECT '0' as dataelementid, '0' as categoryoptioncomboid, ou.organisationunitid as sourceid, '0' as periodid,'DHIS-SYSTEM' as comment, '201308' as periodIsoDate,'dataelementname' as dataelementname, 'optioncomboid' as categoryoptioncomboname, ou.name as organisationunitname, count (psi.programinstanceid ) as value FROM programstageinstance as psi INNER JOIN organisationunit ou on ou.organisationunitid=psi.organisationunitid WHERE EXISTS ( SELECT * FROM patientattributevalue _pav WHERE _pav.patientid = pi.patientid and _pav.patientattributeid=280 AND p.organisationunitid in (0) AND _pav.value )='Especial' ) GROUP BY ou.organisationunitid, ou.name

the error is generated when we edit the aggregation query, but it is don't generated with aggregation query that use the attibutes of patient that it is by default. (Sex).

Thanks,

ING. Helder Yesid Castrillon.
Secretaría departamental de salud

helder_yesid_castril · 26 August 2013 22:47

sorry!!

SEX = gender
In spanish genero, sexo.

ING. Helder Yesid Castrillon.

Tran_Chau · 27 August 2013 04:19

Dear Marko and Helder,

Could you please send to me the formula you created. I can try to test with this formula in my laptop.

Thank you.

···

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Tue, Aug 27, 2013 at 5:47 AM, helder yesid castrillon cobo helder_947@hotmail.com wrote:

sorry!!

SEX = gender
In spanish genero, sexo.

ING. Helder Yesid Castrillon.

From: helder_947@hotmail.com

To: markodavidgm@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 have reviewed in detail and we found that the problem is presented with aggregation query that use the attribute of patient that we have created.
The postgres console print the next error.

__ERROR: syntax error at or near “)” at character 617
STATEMENT: SELECT ‘0’ as dataelementid, ‘0’ as categoryoptioncomboid, ou.organisationunitid as sourceid, ‘0’ as periodid,‘DHIS-SYSTEM’ as comment, ‘201308’ as periodIsoDate,‘dataelementname’ as dataelementname, ‘optioncomboid’ as categoryoptioncomboname, ou.name as organisationunitname, count (psi.programinstanceid ) as value FROM programstageinstance as psi INNER JOIN organisationunit ou on ou.organisationunitid=psi.organisationunitid WHERE EXISTS ( SELECT * FROM patientattributevalue _pav WHERE _pav.patientid = pi.patientid and pav.patientattributeid=280 AND p.organisationunitid in (0) AND pav.value )=‘Especial’ ) GROUP BY ou.organisationunitid, ou.name

the error is generated when we edit the aggregation query, but it is don’t generated with aggregation query that use the attibutes of patient that it is by default. (Sex).

Thanks,

ING. Helder Yesid Castrillon.

Secretaría departamental de salud

Date: Mon, 26 Aug 2013 09:21:39 -0500
From: markodavidgm@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 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,

Ing. Marko David Garcia M.
**Área de Sistemas integrados de Información
Secretaría de Salud Departamental del Cauca
**

_______________________________________________ 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

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

Marko_David_Garcia · 27 August 2013 14:15

Thank you Tran.

“Regimen” is patient attribute created by Us, when we try to test the condition the system show the warning window.

For Example if we use “Genero” = Gender, or if we use the dataelement parameter (‘210 - Dengue’) the query works fine.

Thank you very much.

Cordialmente,

Ing. Marko David Garcia Muñoz

Secretaría Departamental de Salud del Cauca

Área de Sistemas Integrados de Información

Skype: marko_david

···

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Tue, Aug 27, 2013 at 5:47 AM, helder yesid castrillon cobo helder_947@hotmail.com wrote:

sorry!!

SEX = gender
In spanish genero, sexo.

ING. Helder Yesid Castrillon.

From: helder_947@hotmail.com

To: markodavidgm@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 have reviewed in detail and we found that the problem is presented with aggregation query that use the attribute of patient that we have created.
The postgres console print the next error.

__ERROR: syntax error at or near “)” at character 617
STATEMENT: SELECT ‘0’ as dataelementid, ‘0’ as categoryoptioncomboid, ou.organisationunitid as sourceid, ‘0’ as periodid,‘DHIS-SYSTEM’ as comment, ‘201308’ as periodIsoDate,‘dataelementname’ as dataelementname, ‘optioncomboid’ as categoryoptioncomboname, ou.name as organisationunitname, count (psi.programinstanceid ) as value FROM programstageinstance as psi INNER JOIN organisationunit ou on ou.organisationunitid=psi.organisationunitid WHERE EXISTS ( SELECT * FROM patientattributevalue _pav WHERE _pav.patientid = pi.patientid and pav.patientattributeid=280 AND p.organisationunitid in (0) AND pav.value )=‘Especial’ ) GROUP BY ou.organisationunitid, ou.name

the error is generated when we edit the aggregation query, but it is don’t generated with aggregation query that use the attibutes of patient that it is by default. (Sex).

Thanks,

ING. Helder Yesid Castrillon.

Secretaría departamental de salud

Date: Mon, 26 Aug 2013 09:21:39 -0500
From: markodavidgm@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 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,

Ing. Marko David Garcia M.
**Área de Sistemas integrados de Información
Secretaría de Salud Departamental del Cauca
**

_______________________________________________ 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

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

Tran_Chau · 28 August 2013 08:39

Hi Marko,

It works with formula [CA:43567] = ‘Gender’. For formulas like this [CA:43567] = Gender (Gender didn’t put between apostroph ), formulas didn’t work. So if you have any formula similar to the second case, please put value to compare between apostroph (') . This bug will be fixed for 2.13 version as plan.

Thank you, Marko.

···

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Tue, Aug 27, 2013 at 9:15 PM, Marko David Garcia Muñoz markodavidgm@gmail.com wrote:

Thank you Tran.

“Regimen” is patient attribute created by Us, when we try to test the condition the system show the warning window.

For Example if we use “Genero” = Gender, or if we use the dataelement parameter (‘210 - Dengue’) the query works fine.

Thank you very much.

Cordialmente,

Ing. Marko David Garcia Muñoz

Secretaría Departamental de Salud del Cauca

Área de Sistemas Integrados de Información

Skype: marko_david

El 26/08/2013, a las 23:19, Tran Chau tran.hispvietnam@gmail.com escribió:

Dear Marko and Helder,

Could you please send to me the formula you created. I can try to test with this formula in my laptop.

Thank you.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Tue, Aug 27, 2013 at 5:47 AM, helder yesid castrillon cobo helder_947@hotmail.com wrote:

sorry!!

SEX = gender
In spanish genero, sexo.

ING. Helder Yesid Castrillon.

From: helder_947@hotmail.com

To: markodavidgm@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 have reviewed in detail and we found that the problem is presented with aggregation query that use the attribute of patient that we have created.
The postgres console print the next error.

__ERROR: syntax error at or near “)” at character 617
STATEMENT: SELECT ‘0’ as dataelementid, ‘0’ as categoryoptioncomboid, ou.organisationunitid as sourceid, ‘0’ as periodid,‘DHIS-SYSTEM’ as comment, ‘201308’ as periodIsoDate,‘dataelementname’ as dataelementname, ‘optioncomboid’ as categoryoptioncomboname, ou.name as organisationunitname, count (psi.programinstanceid ) as value FROM programstageinstance as psi INNER JOIN organisationunit ou on ou.organisationunitid=psi.organisationunitid WHERE EXISTS ( SELECT * FROM patientattributevalue _pav WHERE _pav.patientid = pi.patientid and pav.patientattributeid=280 AND p.organisationunitid in (0) AND pav.value )=‘Especial’ ) GROUP BY ou.organisationunitid, ou.name

the error is generated when we edit the aggregation query, but it is don’t generated with aggregation query that use the attibutes of patient that it is by default. (Sex).

Thanks,

ING. Helder Yesid Castrillon.

Secretaría departamental de salud

Date: Mon, 26 Aug 2013 09:21:39 -0500
From: markodavidgm@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 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,

Ing. Marko David Garcia M.
**Área de Sistemas integrados de Información
Secretaría de Salud Departamental del Cauca
**

_______________________________________________ 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

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

helder_yesid_castril · 29 August 2013 20:49

It is not our case, all the formulas has apostroph (') in the values. We have identified that the bug is when we do aggregation query using the patients attributes created by us.

Mg. Helder Yesid Castrillon.
Sistemas de información
Secretaría departamental de salud del cauca.

Tran_Chau · 30 August 2013 03:48

Hi Helder,

It’s fixed for 2.12 with revision 11291. Please help me to re-test it on your side. Thank you.

···

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Fri, Aug 30, 2013 at 3:49 AM, helder yesid castrillon cobo helder_947@hotmail.com wrote:

It is not our case, all the formulas has apostroph (') in the values. We have identified that the bug is when we do aggregation query using the patients attributes created by us.

Mg. Helder Yesid Castrillon.

Sistemas de información
Secretaría departamental de salud del cauca.

From: tran.hispvietnam@gmail.com
Date: Wed, 28 Aug 2013 15:39:52 +0700

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

To: markodavidgm@gmail.com
CC: helder_947@hotmail.com; dhis2-users@lists.launchpad.net

Hi Marko,

It works with formula [CA:43567] = ‘Gender’. For formulas like this [CA:43567] = Gender (Gender didn’t put between apostroph ), formulas didn’t work. So if you have any formula similar to the second case, please put value to compare between apostroph (') . This bug will be fixed for 2.13 version as plan.

Thank you, Marko.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Tue, Aug 27, 2013 at 9:15 PM, Marko David Garcia Muñoz markodavidgm@gmail.com wrote:

Thank you Tran.

“Regimen” is patient attribute created by Us, when we try to test the condition the system show the warning window.

For Example if we use “Genero” = Gender, or if we use the dataelement parameter (‘210 - Dengue’) the query works fine.

Thank you very much.

Cordialmente,

Ing. Marko David Garcia Muñoz

Secretaría Departamental de Salud del Cauca

Área de Sistemas Integrados de Información

Skype: marko_david

El 26/08/2013, a las 23:19, Tran Chau tran.hispvietnam@gmail.com escribió:

Dear Marko and Helder,

Could you please send to me the formula you created. I can try to test with this formula in my laptop.

Thank you.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Tue, Aug 27, 2013 at 5:47 AM, helder yesid castrillon cobo helder_947@hotmail.com wrote:

sorry!!

SEX = gender
In spanish genero, sexo.

ING. Helder Yesid Castrillon.

From: helder_947@hotmail.com

To: markodavidgm@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 have reviewed in detail and we found that the problem is presented with aggregation query that use the attribute of patient that we have created.
The postgres console print the next error.

__ERROR: syntax error at or near “)” at character 617
STATEMENT: SELECT ‘0’ as dataelementid, ‘0’ as categoryoptioncomboid, ou.organisationunitid as sourceid, ‘0’ as periodid,‘DHIS-SYSTEM’ as comment, ‘201308’ as periodIsoDate,‘dataelementname’ as dataelementname, ‘optioncomboid’ as categoryoptioncomboname, ou.name as organisationunitname, count (psi.programinstanceid ) as value FROM programstageinstance as psi INNER JOIN organisationunit ou on ou.organisationunitid=psi.organisationunitid WHERE EXISTS ( SELECT * FROM patientattributevalue _pav WHERE _pav.patientid = pi.patientid and pav.patientattributeid=280 AND p.organisationunitid in (0) AND pav.value )=‘Especial’ ) GROUP BY ou.organisationunitid, ou.name

the error is generated when we edit the aggregation query, but it is don’t generated with aggregation query that use the attibutes of patient that it is by default. (Sex).

Thanks,

ING. Helder Yesid Castrillon.

Secretaría departamental de salud

Date: Mon, 26 Aug 2013 09:21:39 -0500
From: markodavidgm@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 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,

Ing. Marko David Garcia M.
**Área de Sistemas integrados de Información
Secretaría de Salud Departamental del Cauca
**

_______________________________________________ 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

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

helder_yesid_castril · 30 August 2013 13:17

Ok, I tested with revisions 11245 and 11290 but the error persist, today I downloaded Dhis the web site (http://www.dhis2.org/downloads\), however it is the same revision (11290).
How I download DHIS 2.12 with revision 11291?.

Mg. Helder Yesid Castrillon.

Sistemas de información
Secretaría departamental de salud del cauca.

helder_yesid_castril · 30 August 2013 16:42

Hi,
I downloaded DHIS 2.13-SNAPSHOT with revision 11846 from DHIS2 App Hub to test, but in this revision the error persist, also we tested in the demo of DHIS to discard errors in ours Data, obtaining the same error.

Mg. Helder Yesid Castrillon.

Sistemas de información
Secretaría departamental de salud del cauca.

Tran_Chau · 31 August 2013 03:14

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 bug on demo server ( with revision 11292 in this morning), it works fine. Can you help me to test it again ?

Best regard,

···

On 30-08-2013, at 23:42, helder yesid castrillon cobo <helder_947@hotmail.com> wrote:

Hi,
I downloaded DHIS 2.13-SNAPSHOT with revision 11846 from DHIS2 App Hub to test, but in this revision the error persist, also we tested in the demo of DHIS to discard errors in ours Data, obtaining the same error.

Mg. Helder Yesid Castrillon.
Sistemas de información
Secretaría departamental de salud del cauca.

helder_yesid_castril · 2 September 2013 14:03

Hi Châu,

Thanks for you collaboration, today we could test these revision (11292) and it has worked very well.

regard.

Mg. Helder Yesid Castrillon.

Sistemas de información
Secretaría departamental de salud del cauca.
Colombia.

Tran_Chau · 2 September 2013 14:12

Congrats, Helder…

···

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Mon, Sep 2, 2013 at 9:03 PM, helder yesid castrillon cobo helder_947@hotmail.com wrote:

Hi Châu,

Thanks for you collaboration, today we could test these revision (11292) and it has worked very well.

regard.

Mg. Helder Yesid Castrillon.

Sistemas de información
Secretaría departamental de salud del cauca.

Colombia.

CC: dhis2-users@lists.launchpad.net
From: tran.hispvietnam@gmail.com

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

Date: Sat, 31 Aug 2013 10:14:28 +0700
To: helder_947@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 bug on demo server ( with revision 11292 in this morning), it works fine. Can you help me to test it again ?

Best regard,

On 30-08-2013, at 23:42, helder yesid castrillon cobo helder_947@hotmail.com wrote:

Hi,
I downloaded DHIS 2.13-SNAPSHOT with revision 11846 from http://apps.dhis2.org/ci/job/dhis-web-2.12/ to test, but in this revision the error persist, also we tested in the demo of DHIS to discard errors in ours Data, obtaining the same error.

Mg. Helder Yesid Castrillon.

Sistemas de información
Secretaría departamental de salud del cauca.

From: helder_947@hotmail.com
To: tran.hispvietnam@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 count

Ok, I tested with revisions 11245 and 11290 but the error persist, today I downloaded Dhis the web site (http://www.dhis2.org/downloads), however it is the same revision (11290)

How I download DHIS 2.12 with revision 11291?.

Mg. Helder Yesid Castrillon.

Sistemas de información
Secretaría departamental de salud del cauca.

From: tran.hispvietnam@gmail.com
Date: Fri, 30 Aug 2013 10:48:17 +0700

Subject: Re: [Dhis2-users] Aggregation Query Builder doesn’t count
To: helder_947@hotmail.com
CC: markodavidgm@gmail.com; dhis2-users@lists.launchpad.net

Hi Helder,

It’s fixed for 2.12 with revision 11291. Please help me to re-test it on your side. Thank you.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Fri, Aug 30, 2013 at 3:49 AM, helder yesid castrillon cobo helder_947@hotmail.com wrote:

It is not our case, all the formulas has apostroph (') in the values. We have identified that the bug is when we do aggregation query using the patients attributes created by us.

Mg. Helder Yesid Castrillon.

Sistemas de información
Secretaría departamental de salud del cauca.

From: tran.hispvietnam@gmail.com
Date: Wed, 28 Aug 2013 15:39:52 +0700

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

To: markodavidgm@gmail.com
CC: helder_947@hotmail.com; dhis2-users@lists.launchpad.net

Hi Marko,

It works with formula [CA:43567] = ‘Gender’. For formulas like this [CA:43567] = Gender (Gender didn’t put between apostroph ), formulas didn’t work. So if you have any formula similar to the second case, please put value to compare between apostroph (') . This bug will be fixed for 2.13 version as plan.

Thank you, Marko.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Tue, Aug 27, 2013 at 9:15 PM, Marko David Garcia Muñoz markodavidgm@gmail.com wrote:

Thank you Tran.

“Regimen” is patient attribute created by Us, when we try to test the condition the system show the warning window.

For Example if we use “Genero” = Gender, or if we use the dataelement parameter (‘210 - Dengue’) the query works fine.

Thank you very much.

<Captura de pantalla 2013-08-27 a la(s) 8.52.00.png>
Cordialmente,

Ing. Marko David Garcia Muñoz

Secretaría Departamental de Salud del Cauca

Área de Sistemas Integrados de Información

Skype: marko_david

El 26/08/2013, a las 23:19, Tran Chau tran.hispvietnam@gmail.com escribió:

Dear Marko and Helder,

Could you please send to me the formula you created. I can try to test with this formula in my laptop.

Thank you.

Best regards,

Châu Thu Trân
HISP Viet Nam
Email: tran.hispvietnam@gmail.com

On Tue, Aug 27, 2013 at 5:47 AM, helder yesid castrillon cobo helder_947@hotmail.com wrote:

sorry!!

SEX = gender
In spanish genero, sexo.

ING. Helder Yesid Castrillon.

From: helder_947@hotmail.com

To: markodavidgm@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 have reviewed in detail and we found that the problem is presented with aggregation query that use the attribute of patient that we have created.
The postgres console print the next error.

__ERROR: syntax error at or near “)” at character 617
STATEMENT: SELECT ‘0’ as dataelementid, ‘0’ as categoryoptioncomboid, ou.organisationunitid as sourceid, ‘0’ as periodid,‘DHIS-SYSTEM’ as comment, ‘201308’ as periodIsoDate,‘dataelementname’ as dataelementname, ‘optioncomboid’ as categoryoptioncomboname, ou.name as organisationunitname, count (psi.programinstanceid ) as value FROM programstageinstance as psi INNER JOIN organisationunit ou on ou.organisationunitid=psi.organisationunitid WHERE EXISTS ( SELECT * FROM patientattributevalue _pav WHERE _pav.patientid = pi.patientid and pav.patientattributeid=280 AND p.organisationunitid in (0) AND pav.value )=‘Especial’ ) GROUP BY ou.organisationunitid, ou.name

the error is generated when we edit the aggregation query, but it is don’t generated with aggregation query that use the attibutes of patient that it is by default. (Sex).

Thanks,

ING. Helder Yesid Castrillon.

Secretaría departamental de salud

Date: Mon, 26 Aug 2013 09:21:39 -0500
From: markodavidgm@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 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,

Ing. Marko David Garcia M.
**Área de Sistemas integrados de Información
Secretaría de Salud Departamental del Cauca
**

_______________________________________________ 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

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

_______________________________________________ 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